Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    12

    Angry Unanswered: Cannot Open User Default Database. Login Failed

    Yesterday was not my best day. I disconnected my database to make a copy of it and forgot to reconnect it before closing SQL Server 2000.

    Now when I try ot access the database I get message.

    Cannot Open User Default Database. Login Failed

    Is there a way to attach the database again or a work around for this?

    Thanks in advance for your help!
    JayD
    Boulder, CO, USA

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You should be able to get an admin to change your default database to pubs, or northwind. Then you would be able to log on, anyway. I am not sure if you would be able to re-attach the database without an admin, though.

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Use the osql.exe utility to run sp_defaultdb and change the default database.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •