When installing System Center Configuration Manager 2012, one of the problems I encountered during the Prerequisite Check was "SQL Server service running account". The detail of the prerequisite check is:
The logon account for the SQL Server service cannot be a local user account, NT SERVICE\ or LOCAL SERVICE. You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.
On the machine with my Microsoft SQL Server 2012 Enterprise installation, I have deleted all the servers except for the reserved account (sa) and the domain account I used to log into the server with (domain\administrator), as per the above error message. However, I continue to receive the above failed requisite error. Are there any other checks I could do to resolve this error?
Best Answer
A step by step instruction can be found here:
http://www.randomtechtips.com/change-logon-account-for-sql-server-service/
1 – Create a dedicate domain account to be used for the SQL Server Service – don’t get into the habit of using your own domain admin account to run services – systems will break when you leave and your reputation will be shot!
2 – Using your Admin tools, open Active Directory Users and Computers
3 – Right-click on an Organizational Unit that will contain your domain user account
4 – Click New, User, create a user account with a meaningful name, with a meaningful description
5 – On the SQL Server, click Start, SQL Server Configuration Manager
6 – Click SQL Server Services, in the right window pane, right-click SQL Server , click Properties
7 – Click the Log On tab, click “This account”, click browse
8- Select the Run Account created earlier
9 – Enter the password (twice to confirm) in the Log on tab, click OK. When prompted to Confirm the Account change, click Yes to restart the service. Click OK to close the properties page.
Ensure the SQL Server service is running with the new domain (service) accoun
Re-run the Prerequisite Check for SCCM 2012 and validate that you do not see the prerequisite for SQL Server service as a warning or failure.