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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2009-06-30 : 00:38:29
|
| Hi Friends,I have a doubt on SQL Security.I am working on SQL 2005 machines.My question is , suppose someone (asy my Jr. DBA) has deleted the BUILTIN\ADMINISTRATORS group from the sysadmin role and i also disabled my "sa" Login. How would i get back or is there any way to recover my sa password or else re-installation is the Solution??????Any thoughts will be greatly appreciated.Thank You! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-30 : 01:36:13
|
Try:login to the machine directly where you have installed the sql server.There you can connect via windows authentication.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-06-30 : 03:38:56
|
| First connect using windows authentication.then do rest of your work |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2009-06-30 : 04:16:14
|
| Guys, Small doubt.If we remove the BUILT\Administrators Group, then how can you get connected to the SQL Server using Windows Authentication? is that possible???Anyways, i will give it a shot and let you know.Thanks! |
|
|
|
|
|
|
How to recover my "sa" password??