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 |
|
Dipti_SQL
Starting Member
2 Posts |
 Posted - 2010-03-05 : 23:46:17
|
Hii,bymistake i removed admin rights of admin user n nw i want to reset it bt i forgt the password of sa user so please help me in recovering sa password or to set password of sa.Thanks in tons,Regards, Dipti SanghviWith Love |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2010-03-08 : 12:51:43
|
| Should be able to log onto your network as an administrator and get SA access to the database server.Edit: Sniped! Should have read more carefully...________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-03-08 : 14:09:15
|
| You can probably gain admin access to SQL Server 2005 by adding your Windows login to one of the following local groups on the server, depending on if it is default or named instance (replace ComputerName and InstanceName with the actual names)Default instance: SQLServerMSSQLUser$ComputerName$MSSQLSERVERNamed instance: SQLServerMSSQLUser$ComputerName$InstanceNameIf that doesn't work, read this article for another method:How to Connect to a SQL 2005 Server When You Are Completely Locked Outhttp://www.sqlservercentral.com/articles/Administration/68271/Once you have admin access to SQL Server, you can change the SA password.You will need to have Windows admin access on the server to do either.CODO ERGO SUM |
|
|
|
|
|
|
How to recover sa password