question

sqlLearner 1 avatar image
sqlLearner 1 asked

XP_CMDSHELL Proxy Failover Cluster

I have 2 instances setup in an active active failover cluster. I am having some trouble setting up a proxy account for xp_cmdshell. When I set up xp_cmdshell proxy for a user lets call it "testuser" on instance 1 all works fine. The issue I am seeing is when I failover instance 1 to instance 2 then the "testuser" can no longer execute xp_cmdshell commands. Is there something specific I need to do to have this work in a failover situation? The credential identity Domain is pointing to the computer name of instance 1. I get this error message: Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1 The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information.
sql-server-2008-r2dbaxp_cmdshellproxy
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
ncd avatar image
ncd answered
Is the proxy account a local or domain login?
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It is the LocalComputerName \\ SQLServiceAccountName
0 Likes 0 ·
Try a domain account as the proxy, the local one is not going to be valid on failover
0 Likes 0 ·
That worked :)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.