Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Just wondering if someone could point me to the right direction. Im about to implement an SQL server on the DC machine. I know that it is not recommended to run the SQL server on the DC but that is all I have.

Anyway, Im trying to figure what type of user accounts I should used for SQL Services. Microsoft suggest Virtual Accounts or MSA some other people are suggesting to create Domain Accounts and then provide proper permissions.

Any suggestions to what should I use? Im looking for a best practice approach and the easiest to implement :)

Thanks

OS Version - Windows Server 2k8 Standard R2 SQL Version- SQL Server 2K8 Standard R2

share|improve this question
    
What will you be using the accounts for? –  squillman Jul 26 '12 at 19:02
    
The following SQL Service Accounts require a user during installation Database Engine SQL Server Agent SQL Server Analysis Services SQL Server Reporting Services Some people suggest to avoid the NT Authority\System because of security reasons and since I have a domain I can't use local accounts. Any thoughts? –  Royer Jul 26 '12 at 19:06
    
I'd use a local virtual service account. both MSA and domain accounts are overly complicated (for different reasons) in this case. –  tony roth Jul 26 '12 at 19:53
    
Thanks. I think I will be using the Virtual Accounts. Do you happen to know how to create them ? The following link technet.microsoft.com/en-us/library/dd548356.aspx mentions that Virtual Accounts cannot be created or deleted. So im confused on how to create them. (Sorry) –  Royer Jul 26 '12 at 20:26
    
I figured it out.. thanks. –  Royer Jul 26 '12 at 21:08
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.