SQL Data Folder Permissions

[googlemad]

Have a server

 

D:\Data Folder with various sub folders (All sub folders inherit D:\Data security as shown below)

 

Security:

 

LOCALSERVER\Administrators Full Control

DOMAIN\Domain Admins Full Control

DOMAIN\SQL Developer User Full Control

 

No permissions being inherited from D:\ drive

 

When trying to create a new DB under D:\Data\SQL_DATA\Data getting an error as attached.

 

If I let D:\Data inherit D:\ drive security permissions everything works fine but I wanted to try and lock down the security as much as possible on this share so trying to work out the specific part it is failing on?

 

[theriver]

Check the account that the SQL Server service us running under - that'll need permission to the folder (likely to be system or network service, depending on the install).