Cannot open user default database.Login Failed | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cannot open user default database.Login Failed

I have a db which contain 5 tables.When I am trying to login with the login id and password i m getting the following error.’Cannot open user default database.Login Failed’.
No doubt the login id and pwd i entered are correct.After that i logged i using sa pwd and tried to query the tables and found only single column in it without any data.
the sid in sysusers and sysxlogins are same , so i guess no prob wid login and user.
What is wrong pls help
Is default user database checked to "that" database?
Can you se the 5 tables using EM?.
If yes, review permission after login with sa.
If no I suppose you have some problem with database no with logins.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
]]>