Used SQL Svr 2008 Config Manager to Set Service Account to Local System: What Did It Change?
- by Frank Ramage
Direct shot to foot moment...
While setting-up individual non-admin accts for MSSQLSERVER services, I temporarily set Server service login to Local System account.
I remembered later that:
SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings.
I want my Local System back . (Actually just restored to its original security profile)
Any advice? Thanks!