September 24, 2002 at 4:23 pm
I am getting the error listed below when I try to run the extended stored procedure xp_sqlagent_proxy_account using either my domain login or the domain login that I had created for SQL Server 2000 to run under (which is also the account that the MSSQLServerADHelper, MSSQLServerOLAPService and the SQLSERVERAGENT services run under). Both domain accounts are members of the Administrators group on the local box that SQL Server runs on.
I also tried setting the proxy account using enterprise manager and got the same error message.
Here is the syntax I used:
exec xp_sqlagent_proxy_account N'SET', N'MyWindosLoginDomain', N'MyLoginName', N'MyPassword'
Error: Unable to set the SQL Agent proxy account because of the reason listed below. 'Error executing extended stored procedure: Specified user can not login'
September 30, 2002 at 8:41 am
I am having the same issue. I have tried several accounts even my own, all come up with the same error. I know that these account can log in. Is there anyone that has solved this issue?
Bill Stevenson
MCSE, MCDBA
Bill Stevenson
MCSE, MCDBA
September 30, 2002 at 8:48 am
Make sure the account has "Log On as a Service" rights (local security policy) on the local box as well. That's the first place to look. However, if the login is already being used for the services, it should already have such rights.
One caution about the ADHelperService. According to the docs it needs to either be a Domain Admin or a LocalSystem account. Obviously Domain Admin isn't necessary. The ADHelper service goes out and registers SQL Server in the AD tree, so it doesn't run very much.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply