Saturday, March 31, 2012

Service Accounts in SQL Server 2012

It is recommended to have different user accounts for each SQL Server services. For example, SQL Server service needs to have a separate account from SQL Server Agent Service.

However, practically many DBAs use same account for all the services. With SQL Server 2012, by default you will get different accounts while installing as shown in following image.

user accounts

No comments:

Post a Comment