In this article I will show you some options to recover from the error "Cannot open user default database. Login Failed". How does this happen? This happens when a login has a default database set, and that database is deleted. When you open any of the Microsoft database tools (like SQL Server Management Studio or Query Anaylzer), it automatically attaches you to the default database. The problem is, that if that database has been deleted, you get the following error message. There are...