Login into sqlserver box

knaren1975
knaren1975 used Ask the Experts™
on
Hi

 I removed the BUILTIN/Administrators login but I disabled my SA account. Is there any way i can get access to sqlserver. DAC is not allowed to get into sqlserver. Is there anyway to get into sqlserver. I know this Question really funny. But its been asked in one of the interviews. Please suggest me how to trouble shoot this issue.

Thx
Naren
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You will have to put SQL server service for that instance into single user mode, then any member of local computer's local administrator group can access SQL server as sysadmin fixed server role. Once logged in under single user mode as sysadmin you can enable sa account.


Have a look at below link

http://msdn.microsoft.com/en-us/library/dd207004.aspx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial