To add on to my earlier replies, I have the following information/inquiries.
I am trying to identify the best accounts to use for each service.
Microsoft SQL Server Best Practices Analyzer is showing the following recommendations:
MSSQLServer Service: domain user account
SQL Server Agent service: domain user account
SSIS Service: Network Service Account
SQL Browser service: Network Service Account
Analysis Service service: Network Service Account
Full Text service: MSSQLServer Service startup account
Reporting services account: domain user account (I believe)
I am pretty sure I have read many other posts/articles that do not specifically say which setup to use for each service, but I do not recall many (if any) posts/articles saying to use the Network Service Account for so many services.
My question is whether I should use around 5 - 7 domain user accounts for the services or if I should follow the Best Practices Analyzer completely and create 3 domain user accounts (1 for MSSQLServer service and Full Text service, 1 for SQL Server Agent service, 1 for Reporting Services service) and use the Network Service Account for all the other services.
I am not looking for answers discussing the trade-off between security and maintenance. I am moreso looking for the best setup from a security standpoint.
Thanks for any info/help on this issue.