SQL Data Folder Permissions
Have a server
D:\Data Folder with various sub folders (All sub folders inherit D:\Data security as shown below)
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?