We help IT Professionals succeed at work.

Cannot Open User Default Database (error 4064)

674 Views
Last Modified: 2008-01-09
I am getting the following error from while connecting  to a database Server (Sql Server 2005)

"Cannot Open User Default Database (error 4064)."

Thanks in advance
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
Avoid using master as the default database. It is a security risk, and users should not have access to the master database.

The default database should be available, and the user should have access to that database.

You can check this by opening Management Studio > security > logins. Find the user and right-click to check the properties. The default database is listed at the bottom of the General page.

If the user does not have permissions to the default database, you will see this error.
Top Expert 2007
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.