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 |
|
heliang
Starting Member
38 Posts |
 Posted - 2013-04-30 : 16:11:15
|
| I have couple SQL servers that nobody knows the SA password and nobody has sys_admin right to reset it. There is no BUILTIN either. Is there anyway to reset the SA password? |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-05-01 : 01:05:27
|
| There is one another approach If any user is a member of Windows Admin Group then log in using that account. After that Start SQL Server in Single User Mode. Create a new login and give it sysadmin permission. |
 |
|
|
|
|
|
how to reset SA password