Why? Error: 18456, followed by Error: Login failed for user 'username'. Reason: Failed to open the explicitly specified database. and then you find out that in your database, there is a user name that has no login name How to fix it? you can use sp_change_users_login to update database user name...