Post reply

cannot connect help asap

  • September 21, 2012 at 12:43 pm

    #281990

    when i start sql and try to connect it says---''cannot open user default database.. login failed'' it says error 4064... what does this mean? i havent changed anything that i know of, just restarted my computer

  • September 21, 2012 at 1:03 pm

    #1540923

    it means the default database the user you are trying to connect with doesn't exist any more...renamed, dropped, whatever.

    you need to log in as an administrator and change the default database of that login.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 21, 2012 at 1:04 pm

    #1540926

    When you set up a login, that user has a defined default database. When the user logs in, that database has to be available to the user of the login can't succeed. So this message indicates that the default database is offline or unavailable for some reason. You have 2 options: bring the database online and re-login, or change the user's default database to a database that is online and re-login.

    And then again, I might be wrong ...
    David Webb

  • September 21, 2012 at 1:33 pm

    #1540945

    article here may help you:

    http://blog.sqlauthority.com/2008/11/04/sql-server-fix-error-4064-cannot-open-user-default-database-login-failed-login-failed-for-user/

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply