none
Installing SQL 2017 clustered instance - Updating permission setting for folder issue RRS feed

  • Question

  • I am installing SQL 2017 enterprise as fail over cluster and running into this issue below.

    PRODSQL is a clustered shared volume. I created sub folder "SQLData" and used that as data folder during sql install.

    I also followed work around mentioned here https://support.microsoft.com/en-us/help/4082888/installation-of-sql-server-on-a-csv-disk-fails-with-permissions-error but still running into this issue. 

    SQL service Account is administrator on the server.

    TITLE: Microsoft SQL Server 2017 Setup
    ------------------------------

    The following error has occurred:

    Updating permission setting for folder 'C:\ClusterStorage\PRODSQL\SQLData\MSSQL14.PRODSQL\MSSQL\DATA' failed. The folder permission setting were supposed to be set to 'D:P(A;OICI;FA;;;BA)(A;OICI;FA;;;SY)(A;OICI;FA;;;CO)(A;OICI;FA;;;S-1-5-80-3017142923-4147168812-3961353769-1417247779-429559477)'.

    Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

    Any ideas? Please Advice.


    Hope it Helps!!


    • Edited by Stan210 Monday, December 2, 2019 6:41 PM
    Monday, December 2, 2019 6:36 PM

All replies

  •  Did anyone else see this error during FCI install? looks like common issue when mount points are involved but the suggestions such as create a subfolder and use that for sql data path, did not work.

    any help is greatly appreciated..


    Hope it Helps!!

    Tuesday, December 3, 2019 2:45 AM
  • Hi Stan210,

    Have you tried to right-click the installer and run as administrator?

    This issue may be related to the service account not having certain permissions.

    Please make sure service account was having below permission in Local Security Policy-> Local Policies-> User Rights Assignment:

    • Act as Part of the Operating System
    • Bypass Traverse Checking
    • Lock Pages In Memory
    • Log on as a Batch Job
    • Log on as a Service
    • Replace a Process Level Token
    • Backup files and directories
    • Debug Programs
    • Manage auditing and security log

    For more detailed, please refer to Updating Permission Setting for Folder Failed and SQL Server installation fails if the Setup account doesn't have certain user rights.

    Hope this could help you.

    Best Regards,

    Amelia Gu


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, December 3, 2019 7:01 AM
  • Thanks Amelia. service account is already admin on the server. 

    I assigned all the permissions listed.

    I tried by launching set up as admin but still the same issue..

    any thoughts?


    Hope it Helps!!

    Tuesday, December 3, 2019 11:50 AM
  • Hi Stan210,

    Could you please refer to the steps in the link to configure FCI?

    https://techcommunity.microsoft.com/t5/Failover-Clustering/Deploying-SQL-Server-2014-with-Cluster-Shared-Volumes/ba-p/371962

    In addition, please make sure to completely remove previous failed installation from Add-Remove Programs.

    Best Regards,

    Amelia Gu


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, December 4, 2019 7:22 AM
  • Yes, I uninstalled and re did the installation. All points mentioned in the video\blog are followed.

    Hope it Helps!!

    Wednesday, December 4, 2019 5:05 PM
  • Hi Stan210,

    Was your issue resolved?

    If you resolve it using your own solution, please share your experience and solution here. It will be very beneficial for other community members who have similar questions.

    If no, please reply and tell us the current situation in order to provide further help.

    Best Regards,

    Amelia Gu


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, December 10, 2019 6:58 AM
  • this is still an issue. any help in solving this is greatly appreciated.

    Hope it Helps!!

    Friday, December 13, 2019 5:31 AM