December 17, 2003 at 12:28 pm
I am running SQL 2K on Windows 2K with SP2. (I am going to go to SP3a this weekend.)
I am trying to add a proxy account so I can have non-sysadmins run the xp_cmdshell procedure. (I am already aware of the problems with this!)
When I run the xp_sqlagent_proxy_account procedure, with the domain, user, and password, I get the following error:
Error executing extended stored procedure: Specified user can not login
I am trying to setup the proxy account as the same account that runs the SQL Server and SQL Server Agent services. I did check to make sure the login and password were correct by logging into the server using this login and password. Everything worked fine.
I have searched the web looking for an answer but I have not found a solution that works for me.
All help is appreciated.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
December 22, 2003 at 8:00 am
This was removed by the editor as SPAM
December 22, 2003 at 8:46 am
Can you post the statement you used?
Be sure to specify the right domain.
Also with the values passed specify the 'N' letter before the value.
December 22, 2003 at 8:54 am
I posted this question in the SQL Server Agent forum and that is where the discussion has been going on. If you have any other input, please go to here:
This will give you more information about what has been suggested and what has been done so far.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply