Wednesday, July 26, 2017

SQL server 2012 cannot be started after reboot

When install SQL server 2012, the service cannot be started after the computer is rebooted. By checking the event log,
it mentions "this service account does not have the required user right log on as a service...".
The solution should add the "Log on as a service" right to an account on your local computer, but unfortunately, add user or group is greyed out by the domain admin.
So the real feasible solution is to uninstall and reinstall, when reinstall, set "NT AUTHORITY\NETWORKSERVICE" as the logon user for all services except "SQL Server Browser"
as it's already set to log on as "NT AUTHORITY\LOCALSERVICE".
To add "NT AUTHORITY\NETWORKSERVICE", input "Network Service" and then click "Check Names".
Now SQL server 2012 is accessible even after restart. And you can run SSMS as administrator to attach the mdf (database) which were created/used before the uninstllation.

No comments:

Post a Comment