What happens if you delete default database for a user in sql server?
--You will get an error msg as : Cannot open user default database
1- Click options in login window
Login Screen in SQL Server Management Studio
2-Set database to master or model
Change database for connection
3-This will fix your login problem. Next step is to find your default database and change that. It is normally located in security> logins> your loginname
Find your Login settings in security tab
4-Change your default database if it is not changed.
Now, you can fix the problem with your default database. Here is the cause of the problem from Mic:
The user default database is unavailable at the time of connection. It is possible that the database:Additionally, the login account may be a member of multiple groups and the default database for one of those groups is unavailable at the time of connection.-->http://support.microsoft.com/kb/307864