SQL SERVER – Setup / Installation Error – Updating Permission Setting for File ResumeKeyFilter.Store Failed

My client contacted me for a quick assistance in a setup trouble. She informed me that it’s a brand-new install and its 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 which popped up during the installation.

Updating permission setting for file ‘H:\System Volume Information\ResumeKeyFilter.Store’ 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-1677750213-2598158969-1042248003)’.
Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.

Your file name might vary but steps would remain same.

WORKAROUND / SOLUTION

We can fix above-mentioned error using steps. But you may want to note that this is not a clever idea to keep the data in the root of a drive. We should create a folder and keep database files inside the folder.

  1. First to view this hidden folder (System Volume Information) click on the view tab and select Hidden Items and go to options tab click on the view tab and unselect Hide Protected Operating System File (Recommended).
    SQL SERVER - Setup / Installation Error - Updating Permission Setting for File ResumeKeyFilter.Store Failed keystore-perm-01
  2. 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 client’s case, it was a domain user called “Susan” so we added her account under permission (full control).

After the permission was given, we click on “Retry” option and setup completed without any further error. I hope this will help you to fix installation error.

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

SQL Error Messages, SQL Server, Starting SQL
Previous Post
SQL SERVER – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.
Next Post
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 1

Related Posts

1 Comment. Leave new

  • Hi, I ran into this same problem and your fix worked, except I couldn’t see the permissions on that file without taking ownership of it first. To resolve it, I changed the owner to the installation account, completed the installation without any further issues, then changed the ownership back to SYSTEM. I did NOT have to add file permissions for the installation account since as the file owner it had what it needed.

    Reply

Leave a Reply