Home Forums SQL Server 2005 Administering Login failed for user 'abc\mssqlsrv'. Reason: Failed to open the explicitly specified database RE: Login failed for user 'abc\mssqlsrv'. Reason: Failed to open the explicitly specified database

  • I know I'm answering an old topic but since I had the same issue it might help somebody else.

    In my case I found that one job had a step configured on a default database which I detach and the job was running once a week.

    The job itself didn't need the default database to run and because of that it wasn't failing.