SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Access is denied (Creating a Folder)
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 4

gsgill76
Posting Yak Master

India
137 Posts

Posted - 10/31/2006 :  04:53:32  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
khtan
sorry me bit confuse, please tell me
How to login locally server machine using the 'Rep' account?
does you mean that in SSMS 'Connect to Server' as
Server name : ServerName\Rep
Authentication :--------
login:------
Password:--------

if this so i am not able to login to the Server with 'ServerName\Rep'

if any other way is there, plz tell me.
Regards,
Thanks.
Gurpreet S. Gill
Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 10/31/2006 :  05:11:36  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
Adding more
I am at clien end (using SSMS), i login in windows as 'Rep' user account( with Admin rights), then login to SQL Server with 'sa' user & password.

then execute the commands

EXEC xp_cmdshell 'DIR \\vsnet5\c$\pppp'
same error

but if i execute it at the command prompt
as

DIR \\client_name\C$
DIR \\client_name\shared_name
MD \\client_name\C$\newww

all working fine

Note: i am in 'Rep' windows user account.

Regards,
Thanks.
Gurpreet S. Gill
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 10/31/2006 :  05:11:44  Show Profile  Send jen a Yahoo! Message  Reply with Quote
ok, so what you're saying is that the backup is done adhoc rather than called in a job?

so client generates backup and directly saves onto their own client machines or do they get saved on the server first then transferred to the client?

is the server on a domain?
can your users use windows authentication?
what is vsnet5? is this client or server?

--------------------
keeping it simple...
Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 10/31/2006 :  05:20:13  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
Jen,
my setup is as

VSNET5 is server name (not in Domain)

VSNET1 is client connectivity tool (only SSMS)

Yes, my SP baclup/Restore are adhoc (no Job is used)

Client wants to save it(backup) directly to their own hard drive, no server space they want to use.(no transfer of data, from Server to Client, only direct save at client end)

Authentication mode is SQL Server (used to login in as 'sa')

Regards,
Thanks.
Gurpreet S. Gill
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17430 Posts

Posted - 10/31/2006 :  06:37:19  Show Profile  Reply with Quote
"How to login locally server machine using the 'Rep' account?"
I mean go to the Server itself and press ctrl-alt-delete to login to the Windows Server Console.

Your problem now is basically access issue. Not really related to SQL Server. This is basically to confirm if the user REP is able to access VSNET1 from VSNET5 (Server).

If you are able to perfrom the following from command prompt (at VSNET5)
DIR \\client_name\C$
DIR \\client_name\shared_name
MD \\client_name\C$\newww
it should be fine


KH

Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 10/31/2006 :  06:47:01  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
Mr khtan
All the command are woking fine at server
quote:

DIR \\client_name\C$
DIR \\client_name\shared_name
MD \\client_name\C$\newww



Then where the things going wrong?
Regards,
Thanks.
Gurpreet S. Gill
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17430 Posts

Posted - 10/31/2006 :  07:15:39  Show Profile  Reply with Quote
then this should be fine also

EXEC xp_cmdshell 'DIR \\VSNET1\C$'

is it ?


KH

Go to Top of Page

Page47
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 10/31/2006 :  07:31:24  Show Profile  Reply with Quote
quote:
Originally posted by samuelclay

The OP stated that he had set SQL Server Agent to start with the new user, the SQL Server service also has to use that acct for start up.



Done sleep on this point.

Jay White
Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 10/31/2006 :  07:33:23  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
quote:

EXEC xp_cmdshell 'DIR \\VSNET1\C$'


sorry man, this returns the same error

Access is denied.
NULL
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17430 Posts

Posted - 10/31/2006 :  07:33:33  Show Profile  Reply with Quote
Good point Jay

gsgill76 is it changed ?


KH

Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 10/31/2006 :  07:35:44  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
quote:
Originally posted by Page47

quote:
Originally posted by samuelclay

The OP stated that he had set SQL Server Agent to start with the new user, the SQL Server service also has to use that acct for start up.



Done sleep on this point.

Jay White




Not sleeping infact looking for easy way, if u thinks that this could be the easy way, please help.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/31/2006 :  17:02:11  Show Profile  Reply with Quote
Run this command in Query analyzer under the account you are trying to do this with, and post the output.
exec xp_cmdshell 'set'



CODO ERGO SUM
Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 11/01/2006 :  00:06:09  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
Hi Michael Valentine Jones
this is the output of
quote:
exec xp_cmdshell 'set'


ALLUSERSPROFILE=C:\Documents and Settings\All Users
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=VSNET5
ComSpec=C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
lib=C:\Program Files\SQLXML 4.0\binNUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=D:\oracle\product\10.1.0\db_1\bin;D:\oracle\product\10.1.0\db_1\jre\1.4.2\bin\client;D:\oracle\product\10.1.0\db_1\jre\1.4.2\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program F
iles\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssembliesPATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PERL5LIB=D:\oracle\product\10.1.0\db_1\perl\lib\5.6.1\MSWin32-x86;D:\oracle\product\10.1.0\db_1\perl\lib\5.6.1;D:\oracle\product\10.1.0\db_1\perl\5.6.1\lib\MSWin32-x86;D:\oracle\product\10.1.0\db_1\perl\site\5.6.1;D:\oracle\product\10.1.0\db_1\perl\site\5
.6.1\lib;D:\oracle\product\10.1.0\db_1\sysman\admin\scripts
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 4 Stepping 1, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0401
ProgramFiles=C:\Program Files
PROMPT=$P$G
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\WINDOWS\TEMP
TMP=C:\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\Default User
windir=C:\WINDOWS
NULL
Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 11/06/2006 :  01:35:22  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
Hi there all
Today only i am able to solve the problem.
the things going wrong was
1) I create Windows user account at SQL Server as 'Rep', with Adminstrative permissios/rights & set the logon account of SQL Server service to 'Rep'.
2) Restart the SQL Server service
DONE !

Now again the questions is there in my mind
i) Why does i need to change the account logon for SQL Server service(it was first as local system)?
ii) I checked that the account permission/rights for windows account by which the windows boots & SQL Server logon, is having same permission/rights as of the default user i.e Administrator. then why the seperate account for that?
(I mean, why need other account, although both 'Administrator' and 'Rep' windows account having same Permission/Rights)?

Regards,
Thanks.
Gurpreet S. Gill
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17430 Posts

Posted - 11/06/2006 :  02:20:02  Show Profile  Reply with Quote
"i) Why does i need to change the account logon for SQL Server service(it was first as local system)?"
Because LOCAL SYSTEM does not has access rights to access remote system


KH

Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 11/06/2006 :  02:28:54  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
Mr khtan,
OK i understand, but i just want to know does this(by changing service accout logon) make any impact on the other operations of SQL Server( like database sevices, replication...etc.)?

Edited by - gsgill76 on 11/06/2006 02:30:27
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 11/06/2006 :  04:31:25  Show Profile  Visit SwePeso's Homepage  Reply with Quote
We have told you already from the first answer...


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

samuelclay
Yak Posting Veteran

USA
71 Posts

Posted - 11/06/2006 :  13:42:22  Show Profile  Visit samuelclay's Homepage  Reply with Quote
All of the operations of the SQL service are going to use the account that the service is started with. AS I pointed out in my first response, the sql agent service and sql service start seperately and each with their own account user/pw..
Go to Top of Page

gsgill76
Posting Yak Master

India
137 Posts

Posted - 11/07/2006 :  01:21:08  Show Profile  Click to see gsgill76's MSN Messenger address  Send gsgill76 a Yahoo! Message  Reply with Quote
samuelclay,
I understand the role of an account service logon, but now i just want to know, does this make many impact(s) on the other operations of SQL Server( like database sevices, replication...etc.), when i change service account for the SQL Server service?
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17430 Posts

Posted - 11/07/2006 :  09:48:19  Show Profile  Reply with Quote
quote:
Originally posted by gsgill76

samuelclay,
I understand the role of an account service logon, but now i just want to know, does this make many impact(s) on the other operations of SQL Server( like database sevices, replication...etc.), when i change service account for the SQL Server service?




No impact. Not that I know off.


KH

Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000