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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2011-11-23 : 10:13:26
|
| Hi Team,our DBA forgot the sa password, and there are no more users having sa pwoers. i know the Administrator password, i logged in to the box with windows authentication. but not able to reset as the built-in-administrators also not having the sa previlleges. please suggest. how can i reset the password or how can i use Administrator to work as Administrator in sql server.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-23 : 14:31:05
|
| Start SQL services in Single user mode -m or -f option. and dont start SQL agent else connection may taken by agent itself. Login as windows administrator or domain administrator. you connect the SQL Server. you will get sysadmin privileges. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-23 : 15:46:33
|
| Isn't that only workable from 2005 onwards?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
sa password reset in 2000