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.
HTH,
-Steven Gott
S/DET
SQL Server
No comments:
Post a Comment