none
SQLServerAgent could not be started (reason: Startup error: The 'msdb' database does not exist)

    Question

  • After installing Service pack 3 for Microsoft SQL Server 2005 the SQLServerAgent wont start:

    From SQLAGENT.OUT:

    2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs)
    2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'master.dbo.sysdatabases'. [SQLSTATE 42S02]
    2010-08-30 17:10:08 - ! [000] Startup error: The 'msdb' database does not exist
    2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs)
    2010-08-30 17:10:08 - ? [098] SQLServerAgent terminated (normally)

    Monday, August 30, 2010 3:17 PM

Answers

  • Hi,

    Please check below things.

     

    a) Whether AGENT XP setting is enabled. You can use below command.

                     sp_configure 'show advanced options', 1;
                     GO
                     RECONFIGURE;
                     GO
                     sp_configure 'Agent XPs', 1;
                     GO
                     RECONFIGURE
                     GO

    b) Whether Service Broker is enabled for MSDB database.

                      SELECT is_broker_enabled FROM sys.databases WHERE name='msdb'

    c)  Also is this is Default Instance or a Named Instance. Please check ALIAS settings.

                     SSMS > SQL Server Agent > Properties > Connection > Alias local host server

          If this is named instance then value should be MACHINENAME\INSTANCE name.

    d) Yes please also check SQL Error Logs if there is some issues with MSDB database only.

     

     


    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/
    Tuesday, August 31, 2010 4:19 AM

All replies

  • Hi,

    Did you restart the machine after sp installation, is the issue with named instance?/

     

    Monday, August 30, 2010 3:52 PM
  • Are you able to view MSDB in SSMS? Hope you have a good backup of that database.

     




    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    Monday, August 30, 2010 4:34 PM
  • Check SQL Server error logs for more details .

    Regards

    Abhay

    Monday, August 30, 2010 4:45 PM
  • Hi,

    Please check below things.

     

    a) Whether AGENT XP setting is enabled. You can use below command.

                     sp_configure 'show advanced options', 1;
                     GO
                     RECONFIGURE;
                     GO
                     sp_configure 'Agent XPs', 1;
                     GO
                     RECONFIGURE
                     GO

    b) Whether Service Broker is enabled for MSDB database.

                      SELECT is_broker_enabled FROM sys.databases WHERE name='msdb'

    c)  Also is this is Default Instance or a Named Instance. Please check ALIAS settings.

                     SSMS > SQL Server Agent > Properties > Connection > Alias local host server

          If this is named instance then value should be MACHINENAME\INSTANCE name.

    d) Yes please also check SQL Error Logs if there is some issues with MSDB database only.

     

     


    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/
    Tuesday, August 31, 2010 4:19 AM
  • Another question:  Did you move the system databases from their default location?  There have been problems reported with Service Packs in SQL Server 2005 if those databases were moved.  They can be moved successfully, but there may be problems if a step was missed. 

    http://support.microsoft.com/kb/918695

    http://www.sqlservercentral.com/articles/Administration/2605/

    RLF

    Tuesday, August 31, 2010 5:25 PM