xpsql.cpp: Error 997 from GetProxyAccount on line 472
I tried searching the knowledgebase but found nothing.
Thank you,
Pablo
You can execute the following to get the proxy account:
exec master.dbo.xp_sqlagent_proxy_account N'GET'
If it doesn't return anything, you need to create the proxy
account.
You can set the proxy account with:
exec master.dbo.xp_sqlagent_proxy_account N'SET',
N'DomainName', N'UserName', N'Password'
-Sue
>.
>