Best practices for Domain Account for SQL Server services
For every DBA this is a big question about performing or following best practices to apply on domain account for SQL Server services. I've done some searching, but have found no definite answer yet. We have a various setup of SQL farm with in our environment with servers are members of Active Directory Services and also run SQL services using an ADS account.
When you open the Configuration Manager you will see atleast 7 services: Integration Services, FullText Search, SQL Server, Analysis Services, Reporting Services, Browser, and Agent. These are visible provided you have installed with all available features of SQL Server.
The following list that are definitive on the aspect of practices you need to follow:
Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx
Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557
At the latest do not forget to test it before deploying on the production enviornment, another set of best practice.