permisssion

[fmardani]

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 fine
But when I log in as a user that I created, it fails with the following message:
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 997 from GetProxyAccount on line 472



I have compared the two users and they seem to have similar permissions.
Any suggestions please?
Thanks

 

[nigelrivett]

I'm guessing your first user is a sysadmin (local administrator?) so will use the sql server service profile. If the second isn't then it will try to impersonate the SQL Server Agent proxy account which looks like it is failing.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.