question

Seanchán avatar image
Seanchán asked

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.
service-account
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
Hi Steve Jones has already created a nice article on the backgroud of the SQL service accounts. [Picking SQL service accounts][1] Microsoft also have a few guidelines of their own.. [msdn][2] [1]: http://www.sqlservercentral.com/articles/Administration/pickingserviceaccounts/2351/ [2]: http://msdn.microsoft.com/en-us/library/ms143691.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Seanchán avatar image Seanchán commented ·
Thanks very much, that answered my question. I also found this link useful: http://technet.microsoft.com/en-us/library/ms143504.aspx
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.