Wednesday, January 23, 2013 6:53 PM
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?
Wednesday, January 23, 2013 7:19 PM
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 :-
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.
Wednesday, January 23, 2013 7:25 PMModerator
Hope this helps.