Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    3

    Unanswered: Recover a Database without credentials

    Is there a way to recover a Database if I don't have the original login credentials?

    The Domian server broke and after fixing it* I cannot connect to SQL anymore

    I always get error 1069, Login failure.

    I would like to recover the database and reset the login credentials

    Thx,
    Uriel

    * Fixiing it = Re-install Win2K server and build Admin and User account with same names and passwords, but likely there are other accounts or provileges that I am missing.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    If you have lost SA and other SYSADMIN privileged account then no way to recover the database, just take full backup and after reinstalling SQL server restore it back.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jun 2003
    Posts
    3
    Thx

    I was assuming the worse.

    Taking charge of someone else system is always a good challenge.

    But anyway I appreciate the response

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    What if you were to build a new system that you have access to, and re-attach the DB files on the new server? Or, you could get a similar result by rebuilding the master DB, applying patches, and reattaching there. These are not things I would like to do to production servers, naturally, but I think they can be done. let me know if you find this works.
    ~Matt

Posting Permissions

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