Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action 
Author Message
 Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action

Hello,

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



Sun, 14 Aug 2005 19:44:14 GMT
 Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action

This is most likely a permissions issue.  

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.



Tue, 16 Aug 2005 00:21:16 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error 22022 SqlServerAgent is not currently running....

2. Error 22022: Service Agent is not currently running

3. SQL Error 22022 SQLServerAgent Job does not exist in the job cache

4. Error 22022 - SQLServerAgent Error: Job

5. Error 22022: SQLServerAgent Error ...

6. Error 22022: SQLServerAgent Error

7. SQLServerAgent error 22022

8. error ORA-01855: AM/A.M. or PM/P.M. required

9. Help!!!----Error 22022, SQLServerAgent Error: Request to run job XXXX refused because the job is already running from a request by Schedule X.

10. Why SQL Agent Refused to run job - error 22022

11. Urgent!!!------Error 22022, SQLServerAgent Error: Request to run job XXXX refused because the job is already running from a request by Schedule X.

12. ...does not exist in the job cache - error 22022


 
Powered by phpBB® Forum Software