I am trying to install a Failover cluster instance and I ran into the following issue:

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)'.

PRODSQL is clustered shared storage (CSV) and it is mounted to C:\ClusterStorage.

The service account is admin account.

Created sub folder - SQLData on the mount point as per Microsoft recommendation.

Please advice if anyone has seen this issue.

  • I suspect permissions are not properly granted on the volume (which requires a different approach than granting permissions to a folder) prior to the install. Check my answer here for more information on this caveat to mount points. Dec 6 '19 at 15:43
  • Hello John, I checked your answer in the other thread. In this case, we are using sub folder <<SQLData>> and using that folder as base for sql install. we do not have any files in mount point drive( C\clusterstorage\prodsql) except hidden files - system volume information and recycle bin.
    – SqlData
    Dec 6 '19 at 17:48
  • Don't know if you ran across this answer or not, but maybe it will provide some relevance for your issue. Dec 9 '19 at 16:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.