I'm trying to setup a proxy account for a SQL Server 2000 instance (for running xp_cmdshield, by the way). I have administrative privilegies on the local server, but not in the domain. The xp_sqlagent_proxy_account procedure expects the domain as a mandatory parameter. I don't see any reason to require a domain account. I would like to use a local account. How I should I configure this to use a local account instead of a domain account?

link|improve this question
feedback

1 Answer

up vote 1 down vote accepted

Use the local server's hostname as the domain. For example, if your server is named server1 then use the account server1\username

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.