SQL Server 2012 Service Accounts and Permissions

Question

For the SQL Server 2012 installation in a large distributed/enterprise envrionment, what is the best practice for SQL service accounts and permissions?

By default it tries to use the virtual account but should I leave it the way it is or use the domain accounts?

If domain accounts then what permissions should be given to those domain accounts?

Answer 1

In my environemnt, I have created domain account having local admin rights on windows server having SQL server installed. And sysadmin rights to this domain account in SQL Server. I have run SQL Service with this domain account.

For more details, refer below link :-

http://blogs.msdn.com/b/askjay/archive/2011/02/28/required-rights-for-sql-server-service-account.aspx

http://support.microsoft.com/kb/2160720?wa=wsignin1.0

---

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

Answer 2

Hello,

You can use Managed Service Accounts also. Please read the following document about the characteristics of each type and decide based on your environment and requirements.

http://technet.microsoft.com/en-us/library/ms143504.aspx#Changing_Accounts

http://technet.microsoft.com/en-us/library/ms143504.aspx#Serv_Accts
 
Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com