Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I installed the SQL Server 2008R2 on the windows server, the computer was not in a domain.

After I installed it, now someone moved the server into a domain.

Problem is: the server can not be accessed anymore, since it is set to windows authentication, the former accounts do not exist anymore, sa is disabled (not set).

Is there any way to change which windows accounts have admin rights to the SQL Server somehow, or do I need to reinstall it?

share|improve this question
up vote 1 down vote accepted

Is there a domain policy that removed the local Windows logins? If not the logins should still be there and be usable.

If the SQL Instance is in Windows only mode, and there are no local accounts which have admin rights to the SQL Server, you'll need to reinstall the instance to get into the SQL Server.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.