| Author |
 Topic  |
|
|
ravilobo
Flowing Fount of Yak Knowledge
India
1183 Posts |
 Posted - 06/26/2006 : 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
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 06/26/2006 : 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... |
 |
|
|
ravilobo
Flowing Fount of Yak Knowledge
India
1183 Posts |
Posted - 06/26/2006 : 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
|
|
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 06/26/2006 : 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... |
|
|
|
dizzyturkey
Starting Member
China
2 Posts |
Posted - 02/03/2010 : 02:14:41
|
I used MS SQL Server Password unlocker to reset sql password, which is safe and easy to use
url removed |
|
|
| |
Topic |
|
SA pwd reset.
