we are occasionally getting
Server message number=15121 severity=16 state=200 line=1 server=MARILYN procedure=xp_cmdshell text=An error occurred during the execution of xp_cmdshell. A call to 'LogonUserW' failed with error code: '1909'.
and this seems to fix it, albeit temporarily!?
Exec sp_xp_cmdshell_proxy_account NULL
Exec sp_xp_cmdshell_proxy_account 'domain\account', 'therightpassword'
any ideas why this may be happening?
this is fully patched w2k3 server R2 SP2 x64; sql2005 SP3 - Microsoft SQL Server 2005 9.00.4053.00 (X64)