April 15, 2004 at 12:24 pm
Hello everyone,
I have a user to whom I have given execute permissions on xp_cmdshell procedure. However, he gets the following error message when he tries to execute:
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 1326 from LogonUserW on line 620
I checked on google, and someone had said that the problem is caused when the sql server service startup account is set from the service window instead of EM. So what I did was I changed the service account for sql server in EM back to "system account" and then back to the username/password that it should be set to. My user still gets the error. Anyone run into this problem before? Thanks in advance for your help.
April 15, 2004 at 1:18 pm
Have you checked the proxy account checkbox for security in SQL Server Agent properties? I believe if you haven't done this, only sysadmins can run xp_cmdshell successfully.
April 15, 2004 at 2:33 pm
I resert the Proxy account in the sql server agent properties page (and the checkbox is off). Thanks for your help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply