Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-06-29 : 06:09:34
|
| Hi,I have created a stored procedure on a sql server machine which calls master..xp_cmdshell This xp handles a file and places it on the network in a folder.When I log into the query analyser as windows user, this sp runs fineBut when I log in as a user that I created, it fails with the following message:Msg 50001, Level 1, State 50001xpsql.cpp: Error 997 from GetProxyAccount on line 472I have compared the two users and they seem to have similar permissions.Any suggestions please?Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-29 : 07:02:25
|
| Well, the SQL user you created won't have permissions to network drives for a start, where-as your windows user name will... |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-29 : 07:31:51
|
| Does your SQL server run on a local system account, or a domain authenticated account?If domain authenticated, does it have rights to the drive?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here!7 |
|
|
|
|
|
|
permission