June 11, 2013 at 9:11 am
I am installing SQL Server 2012 Enterprise (x64) with SP1 on a Windows 2012 SP1 3 node cluster utilizing mount points.
I get the following error during the initial install on the first node:
While updating permission setting for Folder 'z:\SQLDATA\System Volume Information' the permission setting update failed for file 'z:\SQLDATA\System Volume Information\ResumeFilterKey.Store' The folder 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-617070787-1164103636-1191419902-1692725703-799689240)
The 3 workarounds I found all referenced SQL Server 2008 R2. I tried all 3 suggestions and none have worked.
I am thinking this relates to the mount somehow, but I am stuck. And, no, the mount points are NOT in the root of the drive.
Any ideas???
September 4, 2013 at 3:03 pm
Having exact same issue! Installing as Domain admin
September 4, 2013 at 4:08 pm
We got around it by simply adding another folder beneath the mount point folder. Hope it works for you.
September 5, 2013 at 5:06 am
Brad Feaker-195979 (6/11/2013)
I am installing SQL Server 2012 Enterprise (x64) with SP1 on a Windows 2012 SP1 3 node cluster utilizing mount points.I get the following error during the initial install on the first node:
While updating permission setting for Folder 'z:\SQLDATA\System Volume Information' the permission setting update failed for file 'z:\SQLDATA\System Volume Information\ResumeFilterKey.Store' The folder 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-617070787-1164103636-1191419902-1692725703-799689240)
The 3 workarounds I found all referenced SQL Server 2008 R2. I tried all 3 suggestions and none have worked.
I am thinking this relates to the mount somehow, but I am stuck. And, no, the mount points are NOT in the root of the drive.
Any ideas???
You cannot apply security permissions to the mounted folder itself, you must create an install folder under the mounted volume, this is listed inn the best practice when using mounted volumes.
My article here[/url] cites the following
Perry Whittle
- Do not install software to the root of the mount point. Rather, create and install into a folder under the mount point to allow the correct propagation of permissions.
- Ideally, the root drive should not have any data created upon it, it is merely the root tree for the new volumes.
- Permissions applied to the root drive file system do not propagate to the mount point file systems, they are controlled separately.
- Mount points are not supported for all SQL Server 2000 configurations (in case you had a burning desire to use them). This is detailed in the relevant section above.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply