March 7, 2003 at 11:58 am
I have server running sql2k sp3.
When i try to excute the xp_sqlagent_proxy_account i get the following error.
Error executing extended stored procedure: Specified user can not login
I have the following local policies set for the SQL agent account .
1.Act as part of the operating system
2.Bypass traverse checking
3.Increase quotas
4.Log on as a batch job
5.Log on as a service
6.Replace a process level token.
any help??
Thanks,
MK
March 7, 2003 at 12:25 pm
Execute permissions for xp_sqlagent_proxy_account default to members of the sysadmin fixed server role.
Make sure the login you used is able to access SQL Server with 'sa' privilege.
March 7, 2003 at 12:27 pm
it has admon permissions on the box
March 7, 2003 at 12:30 pm
Try to reset the proxy account from the job system tab of SQL Server Agent Properties.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy