1

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?

kishore
  • 872
  • 3
  • 13
  • 28
  • 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. http://support.microsoft.com/kb/2019402 – mrdenny Jan 12 '11 at 00:25

1 Answers1

1

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.

kishore
  • 872
  • 3
  • 13
  • 28