Microsoft recommends that you do not use the Network Service account to run the SQL Server service (see http://msdn2.microsoft.com/en-us/library/ms143504.aspx).
Can anyone tell me what the drawbacks are of doing this?
The Service account is a sysadmin on SQL Server so if I had another application running as the service account that application could authenticate to SQL Server as sysadmin.
When you run as local system then you can potentially harm the windows OS.
When you run as network Service then other services can potentially harm you.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?