Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Xp_cmdshell failure message Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2007 8:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 05, 2012 12:54 PM
Points: 11, Visits: 265
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
Post #434808
Posted Wednesday, December 19, 2007 9:37 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:49 AM
Points: 1,476, Visits: 2,099
You mean they can't connect to the server at all, or they can connect, but just can't get xp_cmdshell to work?

Jason Shadonix
MCTS, SQL 2005
Post #434835
Posted Wednesday, December 19, 2007 1:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 05, 2012 12:54 PM
Points: 11, Visits: 265
They can connect but not execute the xp cmd shell

Thanks
Post #434936
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse