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