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.
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 account2. 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 removed3. 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 problemor, if you have backups of your databases, reinstall sql server --------------------keeping it simple... |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-26 : 04:00:49
|
1. NO2. 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
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... |
|
|
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 useurl removed |
|
|
|
|
|
|
|