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