Post reply

Error 4064

  • October 10, 2008 at 7:10 am

    #124267

    Server SQL 2005. OS Win2003 SP2.

    I am the Admin of the Server.

    A detach operation of my default DB (serious mistake I know!) failed half way.

    The DB is now in Single User Mode.

    I get the following error:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Cannot open user default database. Login failed.

    Login failed for user . (Microsoft SQL Server, Error: 4064)

    I am in a vicious circle, anything I try (e.g. changing the default DB, detach the DB, etc) ends with the message above.

    Is there a way to break this vicious circle? For example by completely detaching that database.

    Thank you very much.

    Thank you very much for your help,

    Dinu

  • October 10, 2008 at 7:24 am

    #883391

    Check the following link

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=167068&SiteID=1

  • October 10, 2008 at 7:47 am

    #883411

    Thank you.

    I already applied the solutions recommended there but I still am in that vicious circle.

  • October 10, 2008 at 8:12 am

    #883427

    Thanks Vyas. I repeated one of the procedures suggested in that thread and this timein worked.:D

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

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