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 |
|
luv26u
Starting Member
2 Posts |
 Posted - 2007-07-27 : 07:31:18
|
| Hi,I removed built-in- Administrators for security purposesand now I can not access ms sql enterprise manager please help! |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-07-27 : 09:18:56
|
| there was an VERY RECENT article either here (or on sqlservercentral) about resolving this. i think it has to do with ptutting SQL Server into single-user mode. Here 's the link.http://www.sqlservercentral.com/newsletter/view_newsletter.asp?id=2469"You have just removed the builtin/Administrators group from your SQL Server 2005 sysadmin group and you realize that no other users are set up with the sysadmin role. You cannot remember the sa password. What can you do?Answer: Start the instance in single user mode and connect as a member of builtin\Administrators to reset the sa password.Explanation: In SQL Server 2005, even if you remove builtin\Adminstrators, you can still use this group to access the server if you start the server in Single User mode. This provides you with a disaster recovery backdoor. Ref: Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005 - http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-28 : 00:24:25
|
| It used to work in earlier versions of sql, Microsoft took it out in sql2k for security reason. |
|
|
|
luv26u
Starting Member
2 Posts |
Posted - 2007-07-29 : 14:36:20
|
| Thanks very much for your replies! I was able to fix the problem byediting the registry and changing SQL back to mix authentication. And,I was able to login using SA user. I could not login as SA user before because login was set to windows authentication only. |
|
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2007-07-29 : 23:21:34
|
| Can you tell us which key you edited in registry?Donn Policarpio |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-30 : 23:22:25
|
| LoginMode under hklm\software\microsoft\microsoft sql server\mssqlserver. |
|
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-04-23 : 08:26:43
|
quote:
Originally posted by AndrewMurphy
there was an VERY RECENT article either here (or on sqlservercentral) about resolving this. i think it has to do with ptutting SQL Server into single-user mode. Here 's the link.http://www.sqlservercentral.com/newsletter/view_newsletter.asp?id=2469"You have just removed the builtin/Administrators group from your SQL Server 2005 sysadmin group and you realize that no other users are set up with the sysadmin role. You cannot remember the sa password. What can you do?Answer: Start the instance in single user mode and connect as a member of builtin\Administrators to reset the sa password.Explanation: In SQL Server 2005, even if you remove builtin\Adminstrators, you can still use this group to access the server if you start the server in Single User mode. This provides you with a disaster recovery backdoor. Ref: Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005 - http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx"
Hi,useful information. How can i do the same in SQL server 2000?Regards,Sathieshkumar. R |
|
|
|
|
|
|
Can not access enterprise manager