July 17, 2003 at 12:04 pm
Hi all. i am getting this error :
(Msg 50001, Level 1, State 50001
xpsql.cpp: Error 87 from GetProxyAccount on line 604)
when i run this command:
EXEC master..xp_cmdshell @CommandLine , NO_OUTPUT
what may be a problem in this case?
any suggestions?
Thank you
July 17, 2003 at 12:09 pm
From EM --> Management --> SQL Server Agent --> properties --> Job System --> uncheck 'Only user with sysadmin ....'. Please ensure you have proxy account defined too.
July 17, 2003 at 12:21 pm
quote:
From EM --> Management --> SQL Server Agent --> properties --> Job System --> uncheck 'Only user with sysadmin ....'. Please ensure you have proxy account defined too.Thanks a lot,i uncheked it but i am not familiar with a proxy account and the window ask me to enter one.what kind of accounts are they?
July 17, 2003 at 12:33 pm
It can be domain user account or local user account, depending on what you want to do with it.
SQL Server Agent proxy accounts allow SQL Server users who do not belong to the sysadmin fixed server role to execute xp_cmdshell and own SQL Server Agent jobs. If the SQL Server user executing xp_cmdshell is not a member of the sysadmin fixed server role, SQL Server executes the command using the Windows account specified as the SQL Server Agent proxy account. If no SQL Server Agent proxy account has been set, the user gets an error.
Edited by - Allen_Cui on 07/17/2003 12:38:49 PM
July 17, 2003 at 1:42 pm
Thank you very much, it works on the test server and i used the account for sqlagent
but when i tried the same procedire on production i got this error :
xpsql.cpp: Error 1314 from CreateProcessAsUser on line 636
i am confused and please help
Edited by - trans52 on 07/17/2003 2:05:18 PM
July 17, 2003 at 2:12 pm
Do both SQL Srever have same version and service pack?
July 17, 2003 at 2:16 pm
quote:
Do both SQL Srever have same version and service pack?Test server has Developer edition with sp3 and production has Enterprise with sp3
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply