Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SA pwd reset.

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-06-26 : 03:25:01
How to reset the SA password, when built in administrator access has been removed?

------------------------
I think, therefore I am - Rene Descartes

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-06-26 : 03:54:54
1. do you have any account with sa privilege?
--if yes, use this account

2. are the sql services running in domain account?
--if yes, use this account to gain access
--if you don't know the password for the service account(s), look for a sql server with the same service account and try to login there, hoping that builtin was not removed

3. if no for 1 & 2, ask for 'professional' help, i think there are services/businesses out there that will help you with this type of problem

or, if you have backups of your databases, reinstall sql server

--------------------
keeping it simple...
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-06-26 : 04:00:49
1. NO
2. Yes. But that doesn't have SA privilege!
3. If I reinstall, then I lose server level objects. DTS, JOBS, LOGINS etc..

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-06-26 : 05:59:40
2. what are the permissions you provided to the sql service account?
3. i meant backups for all including your system databases




--------------------
keeping it simple...
Go to Top of Page

dizzyturkey
Starting Member

2 Posts

Posted - 2010-02-03 : 02:14:41
I used MS SQL Server Password unlocker to reset sql password, which is safe and easy to use

url removed
Go to Top of Page
   

- Advertisement -