Problem
While testing out MSSQL 2012 Always On Failover Clustering in my lab, I stumbled upon a strange error which I have never seen before: “Updating permission settings for file [Shared drive]\[Mountpoint]\System Volume Information\ResumeKeyFilter.store failed”. This happened for all drives that was mounted as a mount point (folder) instead of a drive letter.
Update
Sample error from summary.txt log:
Feature: SQL Server Replication
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x84CF0004
Error description: While updating permission setting for folder 'S:\MountPoint\System Volume Information' the permission setting update failed for file 'S:\MountPoint\System Volume Information\DpmFilterBitmapDL{101BD42A-15D6-4232-B792-3C6B2BD2DCB4}'. 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;;;SID)'.
Analysis
My lab is running Windows Server 2012 DataCenter Edition, and I am using a QNAP nas with ISCSI as shared storage. After searching the web a bit, I found similar errors referring to SQL 2008 when not running setup as admin, so I tried running setup explicitly as administrator to no avail. I also tried formatting the drives, still no go. Furthermore, when I cancelled the setup the cluster resource didn’t uninstall completely, so I ended up with a stale resource group. The VM’s were fresh installs, so there shouldn’t be any other conflicts. I haven’t been able to find any references to this specific error anywhere else, but the resume key filter file seems to be related to Windows 2012’s new transparent failover feature for SMB 3: http://blogs.technet.com/b/clausjor/archive/2012/06/07/smb-transparent-failover-making-file-shares-continuously-available.aspx.
Workaround
To get around the problem, I tried fiddling with the permissions of the file manually. I found that taking ownership of the file and setting the Domain Administrator account as owner let the cluster installation procedure add the permissions it needed.
when I took ownership, SYSTEM was the only account that had access. After setup was done, Domain administrators and the MSSQLSERVICE (instance) service account had been granted “Full Control” permissions on the files.
Nice article! This worked for us.
God bless you
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.