Error message: sql server error 42000 cannot open database


  • Hello eveyone

    I am using sql server 2008 r2 maintainance plan. I take the weekly backup of (multaqaSSDB) database

    The job was succeeded....But in sql server agent (log file viewer) I get the message

    [298] SQLServer Error: 4060, Cannot open database "MultaqaSSPDB1" requested by the login. The login failed. [SQLSTATE 42000] 

    but I don't have (MultaqaSSPDB1)this database in instance......


    please help me how can I solve this issue

    Note: There is two job related  to this database:

                         1.    MultaqaSSPDB_Job_DeleteExpiredSessions

                         2.    MultaqaSSPDB1_Job_DeleteExpiredSessions

    please need your responce



    Wednesday, July 4, 2012 10:11 AM


  • Maybe in the Maintenance Plan you have specified the databases, and you later deleted the database. Did you ever had MultaqaSSPDB1 database in your server?

    Open the Maintenance Plan and check which databases are selected for the each task. There should be MultaqaSSPDB1 in them.

    Wednesday, July 4, 2012 2:02 PM

All replies