SQl Server Agent does not start

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQl Server Agent does not start

Author

Topic

maximx86
Starting Member

4 Posts

Posted - 2007-06-18 : 05:08:26

I cannot run SQl Server Agent service. Each time I try I get these 2 errors

Event Type: Error
Event Source: SQLAgent$MY_INSTANCE
Event Category: (2)
Event ID: 17310
Date: 18/06/2007
Time: 09:27:49
User: N/A
Computer: MY SERVER
Description:
A user request from the session with SPID 53 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:

Event Type: Error
Event Source: SQLAgent$MY_INSTANCE
Event Category: Service Control
Event ID: 103
Date: 18/06/2007
Time: 09:27:49
User: N/A
Computer: MY SERVER
Description:

SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the msdb database is not set to a compatibility level of 70 or higher).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I am on SQL Server 2005. Do you have any ideas what might cause it and how to fix it?

Chris

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-18 : 05:19:50

set the msdb compatiblity to 9.0

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

maximx86
Starting Member

4 Posts

Posted - 2007-06-18 : 05:39:01

I ran EXEC sp_dbcmptlevel 'msdb'

and received

The current compatibility level is 90.

Running query sp_dbcmptlevel I am receing
Valid values of the database compatibility level are 60, 65, 70, 80, or 90.

Trying to get properties of my database I get this:
http://extranet.aesfinance.com/files/sql.png

Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-18 : 06:03:12

about the GUI error:
exit and restart the SSMS. if the error persists you'll have to reinstall the SSMS.

does the sql server log provide any more info?
what compatibilty are your db's set to?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources