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?
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).
There are currently 1 users browsing this thread. (0 members and 1 guests)