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.