Permission error occurs when you use a volume mount point in SQL Server Setup

Symptoms
When you install Microsoft SQL Server 2012 or Microsoft SQL Server 2014 on Windows Server 2012, the installation fails if you assign a SQL Server system folder (such the DATA or LOG files location) to a volume mount point root folder. Additionally, you receive the following error message:

While updating permission setting for folder 'T:\DATA\System Volume Information' the permission setting update failed for file 'T:\DATA\System Volume Information\ResumeKeyFilter.Store'. 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-3880718306-3832830129-1677859214-2598158968-1052248003)'.
Cause
This problem occurs because SQL Server Setup does not have permission to access the \System Volume Information\ResumeKeyFilter.Store file.
Resolution
To resolve this problem, create a subfolder in the volume mount point, and assign the new subfolder to the SQL Server system folders.
More information
When SQL Server Setup configures SQL Server system folders, Setup tries to change the permissions of folders and the files that are in those folders. But if you set the system folders to a root folder of the volume mount point, the \System Volume Information\ResumeKeyFilter.Store file is created on Windows Server 2012. SQL Server Setup cannot change the permissions of ResumeKeyFilter.Store because SYSTEM is the only permission that is set on this file.
Properties

Article ID: 2867841 - Last Review: 08/25/2015 22:19:00 - Revision: 2.0

Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2012 Web, Microsoft SQL Server 2012 Express, Windows Server 2012 Datacenter, Windows Server 2012 Standard

  • kbbug kbfix KB2867841
Feedback