Does anyone have a solution to this issue please?

I cannot get SQlServerAgent on SQL2000 SP3 to run any jobs? I have
SQL7 running as the default instance and SQL2000 running as instance
SQl2000.

The Windows account that SQlAgent is running under is a member of the
Sysadmin server role in SQL2000, and has all the correct registry
access, can run as a service, etc. Even with this account running as
an Administrator I still get the same error.

The Application Event reads...
SQLServer - You do not have sufficient operating system permission to
open the SQLServerAgent status event.
SQLAgent - The data portion of event 17052 from MSSQL$SQL2000 is
invalid.

I can start and stop

Mark Derman

Make sure the account SQLAgent starting under has permissions to
Replace A process level token
Increase Quotas
Logon as a service.

Books online states that the account needs to be a member of the local admins group as well.

Want to know more? Check out the MSDN Library at http://msdn.microsoft.com  or the Microsoft Knowledge Base at http://support.microsoft.com

Scot Rose, MCSD
Microsoft Visual Basic Developer Support

This posting is provided AS IS, with no warranties, and confers no rights.