SQL Server 2008 R2 Services

[bikerboy718]

When selecting a user account to start an sql server instance what is the best service account to use. Should one of the service accounts be used or should a watered down domain account be used. I know that for 2000 it was recommended to use a domain account. Can some one explain to me the best account to use and why? Any help would be greatly appreciated.

With Great Power Comes Great Responsibility!!!

Michael

 

[gmmastros]

I usually use 'Local System' for the services. If you need to move files among various servers using TSQL, then you need to use a domain account that has privileges to the various folders.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bikerboy718]

What about using the Network Service Account? I guess what I am trying to figure out is what are the pros and cons of the Local Service Account, the Network Service Account, and a Domain Account? And which one would be considered a best practice for a production server and why? This is one are a that I am trying to better understand.

With Great Power Comes Great Responsibility!!!

Michael