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.

I am trying to change the account of sql server service from LocalSystem to a domain user account. It is giving me an error "No mapping between account names and security IDs was done"

The server is an additional domain controller in the network. Before changing the service account to domain user I have created the domain user login from windows in sql server. Can someone please help?

share|improve this question
1  
Are you using the services control panel to change the account, or the SQL Server Configuration Manager? It is recommended that you not run SQL Server on a domain controller. –  mrdenny Jan 11 '11 at 21:28
    
I am using SQL Server Configuration Manager to change the account. The sql server I am installing will just server as a witness in a mirroring setup. –  kishore Jan 11 '11 at 21:32
1  
Did you install SQL, then promote the machine to being a domain controller? This MSKB may apply. support.microsoft.com/kb/2019402 –  mrdenny Jan 12 '11 at 0:25

1 Answer 1

up vote 0 down vote accepted

Thanks @mrdenny. Sql server was pre existing on the the server and later the server was made as an additional domain controller. Doing a fresh installation of sql server fixed my problem. I had to use this workaround to uninstall sql server instance http://support.microsoft.com/kb/925976

Sql server was serving as a witness so I didn't have any problem for a fresh installation. But it is recommended not to run SQL Server on domain controller.

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.