SQL Server NETWORK SERVICE account permissions
Posted
by
RemotecUk
on Server Fault
See other posts from Server Fault
or by RemotecUk
Published on 2012-07-04T07:36:45Z
Indexed on
2012/07/04
9:18 UTC
Read the original article
Hit count: 266
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.
© Server Fault or respective owner