SQL Server Performance Forum – Threads Archive
Cannot open user default database.Login FailedI 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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.