After consulting Books Online (which says, "Run separate SQL Server services under separate Windows accounts.") and reading this editorial and the resulting discussion on SQLServerCentral.com, I decided that each service of each instance should use a unique account. Here's my naming convention:
You can see that I've collected the accounts into a Group named 'SQL Server Accounts', and that they follow this naming convention:
- SQL - so all the SQL Server accounts will be listed together
- Instance Name - 'PJM' in this case
- Account Name - SQL Agent, Database Engine, Analysis Services, Integration Services or Reporting Services
No comments:
Post a Comment