question

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.