SQL Server Services "Log On As" accounts. What should they be?
**SQL Server 2008** **Windows Server 2008 R2 Enterprise** After Microsoft Updates and a restart, the "Log On As" accounts for some of the SQL Server services had changed to ".\Administrator". Another question on this site led me to change the "SQL Server" to NetworkService to fix connectivity. This now works fine. I can connect to the DB again. What are the defaults for the other services though? I have three other services with ".\Administrator" still on them: 1. SQL Server Integration Services 10.0 2. SQL Server Analysis Services 3. SQL Server Reporting Services Should they be "LocalService", "System", or "NetworkService"? Thanks.