Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.