SQL SERVER – Installation Error – Updating Permission Setting for File Failed

SQL
3 Comments

My client contacted me for a quick assistance in a setup trouble. She informed it’s a brand-new install and failing at the end. She was installing SQL Server 2016 on Windows Server 2016. Let us learn about how to fix Installation Error.

Below was the error message

Updating permission setting for file ‘H:\System Volume Information\WPSettings.dat’ failed. The file permission setting was 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-3880718306-3832830129-1677759213-2598158969-1052248003)’.
Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.

SQL SERVER - Installation Error - Updating Permission Setting for File Failed erroricon-800x536

WORKAROUND / SOLUTION

The error was having the retry option. I looked into the configuration file ConfigurationFile.ini and found that she was using the H drive for TempDB. The location he specified for TempDB was a root directory of H drive. From the error message it looks like the SQL Server setup may not be able to add required permissions on the root directory.

So, I asked her to create a folder instead and then specify that in TempDB location. We cancelled the setup and she reverted the snapshot to initial state where SQL was not installed and created a folder for TempDB. For other files such as System DB’s, User DB’s and Backup’s she had already created folder.

After creating the folder, the installation was successful.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQL SERVER – Service Pack Failure: MissingRegistryKeyException
Next Post
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’

Related Posts

3 Comments. Leave new

  • Ghouse M Khan-Mubeen
    March 28, 2018 4:45 pm

    Resolved

    First to view this hidden folder (System Volume Information) click on view tab and select Hidden Items and also go to options tab click on view tab and unselect Hide Protected Operating System File (Recommended).

    To resolve issue I go to G:System Volume Information folder and right click on file ResumeKeyFilter.Store click on properties and in security tab add your installation user, in my case I’m using domain user called grid and add this user for permission.

    Reply
  • Vandan Kanjariya
    September 4, 2020 5:51 am

    Thank you Ghouse M Khan-Mubeen :)

    Reply

Leave a Reply

Menu