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.

My SQL Server Windows service is set to use the NETWORK SERVICE account.

The server is installed to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL.

However looking at the permissions on that folder, NETWORK SERVICE does not have any permissions. The groups which are allowed access to that folder are...

  • CREATOR OWNER - who is this?
  • SYSTEM - sounds fine - so that Windows can access the folder I presume?
  • SQLServerMSSQLUser$Computer_Name$MSSQLSERVER - this is the interesting one - what is this?
  • Administrators
  • Users

If NETWORK SERVICE is a user with minimal permissions on the system and looks to the O/S as someone connecting from a network how does it have permissions to access any files in the SQL Server install folder?

Thanks.

share|improve this question
add comment

1 Answer

The group SQLServerMSSQLUser$Computer_Name$MSSQLSERVER should be a local group created during SQL Server setup, and if you specified network service as the service account during setup that user should be in that group. That membership allows access to the MSSQL folders and files.

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.