SQL 200 - Lost SysAdmin Access and SA Password

Posted on 2009-02-17
Last Modified: 2012-05-06
Quick rundown on my situation; SA password is unknown, I've no accounts with BuiltIn\Administrators access. As far as I can tell all groups/users have been removed SQL and BuiltIn\Admin. I do have local and Domain Admin access to the SQL server. The version is SQL 2000 SP3.

Currently the SQL Server Agent service can't be started either without persmissions. So I'm left with manually stopping the SQL services to get backups of my DB's.

Where do I go from here? I'm thinking I'll need to move the DB files to another instance/install but now sure how the details of that process would play out.
Question by:Jason Wilcox
    LVL 13

    Accepted Solution

    Been a while since I've been in a situation like this...

    Think rebuilding the master database may be your only option; however this will reset everything...including users/passwords...

    Lookup "rebuildm"

    LVL 75

    Expert Comment

    by:Anthony Perkins
    You can try detaching the databases and reattaching to a new server, but you are still stuck recreating all the Logins.
    LVL 3

    Author Closing Comment

    by:Jason Wilcox
    Perfect, thanks for the post.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now