+ Post New Thread
Results 1 to 2 of 2
Enterprise Software Thread, SQL Data Folder Permissions in Technical; Have a server D:\Data Folder with various sub folders (All sub folders inherit D:\Data security as shown below) Security: LOCALSERVER\Administrators ...
  1. #1

    Join Date
    Jan 2007
    Posts
    973
    Thank Post
    10
    Thanked 42 Times in 28 Posts
    Rep Power
    24

    SQL Data Folder Permissions

    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?

    sql.png

  2. #2

    Join Date
    Apr 2006
    Posts
    388
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    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).

SHARE:
+ Post New Thread

Similar Threads

  1. Student drop box (homework folder) permissions
    By ashdon in forum How do you do....it?
    Replies: 21
    Last Post: 8th October 2012, 04:42 PM
  2. Replies: 6
    Last Post: 11th April 2007, 04:30 PM
  3. Replies: 5
    Last Post: 12th January 2007, 09:26 PM
  4. Folder Permissions
    By wesleyw in forum Windows
    Replies: 6
    Last Post: 9th January 2007, 08:25 PM
  5. DPS Folder Permissions
    By ajbritton in forum ICT KS3 SATS Tests
    Replies: 2
    Last Post: 18th December 2006, 11:09 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •