how to resolve this error

Posted by Parthibansk under Sql Server on 9/11/2012 | Points: 10 | Views : 917 | Status : [Member] | Replies : 1
SQL SERVER - Fix : Error: 4064 - Cannot open user default database. Login failed. Login failed for user..

i get this error when i tried to login windows authentication for sqlsever..


Posted by: Vasanthmvp on: 9/11/2012 [Member] Starter | Points: 25

Hi, I think there might be a typo error in the username & password to login (OR) check with the server name
- If this is not the case: the database access permissions might be the problem
- You try to log in through windows authentication and see if you can access the default database. If you can access, then there might be a mismatch in the login credentials.
- Refer the link:

If i'm wrong plz correct me.

Awesome Coding !! :)

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response