Home / server / Questions / 221270
Accepted
kishore
Asked: 2011-01-12 12:39:23 +0800 CST

Running sql server service on domain user account

  • 772

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?

windows-server-2008 sql-server domain

1 Answers

  1. Best Answer

    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.

    • 1