Login failed for user . Reason: Failed to open the explicitly specified database.


  • We are receiving this error for a particular login on one server. SQL 2008 Enterprise

    The default db is set to master, but it doesn't have rights to master.

    I ran a trace and see that it's trying to access the Master db.

    We have this login on other server with the same setup, but they aren't having issues.

    Any ideas?




    Tuesday, October 18, 2011 5:14 PM


  • We found it was a bad connection string which was including the 'Master' as the database.

    Since it didn't have rights to Master, it wouldn't log in.

    • Marked as answer by w84me Thursday, October 20, 2011 4:24 PM
    Thursday, October 20, 2011 4:24 PM

All replies