Post reply

Xp_cmdshell failure message

  • December 19, 2007 at 8:35 am

    #121505

    Hi

    We have recently changed our SQl service account that our sql server agent uses. Now non -SA users cannot login and they get the following message:

    Msg 50001, Level 1, State 50001

    xp_cmdshell failed to execute because LogonUserW returns error 1326.

    please make sure the service account SQL Server running under has

    appropriate privilege. For more information, search Book Online for

    topic related to xp_sqlagent_proxy_account.

    We did go into sql agent properties and reset the proxy account to the new password.

    However the error still persists.

    Any help is appreciated.

    Thanks

  • December 19, 2007 at 9:37 am

    #761448

    You mean they can't connect to the server at all, or they can connect, but just can't get xp_cmdshell to work?

    The Redneck DBA

  • December 19, 2007 at 1:08 pm

    #761534

    They can connect but not execute the xp cmd shell

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply