Access to SQL Server when administrator account deleted

Posted by Shiraz Bhaiji on Server Fault See other posts from Server Fault or by Shiraz Bhaiji
Published on 2010-12-20T09:45:20Z Indexed on 2010/12/24 0:56 UTC
Read the original article Hit count: 209

An interesting situation here.

We have a database server, used for testing only, where someone went in and deleted the administrator login.

Since this is a test server the was no other admin level login on the server.

Is there a way to get access to the server again without reinstalling SQL Server?

We do not need the data in the databases, these are droped and recreated everytime the tests are run.

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about login