Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2012 cluster install error Expand / Collapse
Author
Message
Posted Tuesday, June 11, 2013 9:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 5, 2014 7:28 AM
Points: 2, Visits: 50
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???
Post #1462215
Posted Wednesday, September 4, 2013 3:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:25 PM
Points: 1, Visits: 267
Having exact same issue! Installing as Domain admin
Post #1491546
Posted Wednesday, September 4, 2013 4:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 5, 2014 7:28 AM
Points: 2, Visits: 50
We got around it by simply adding another folder beneath the mount point folder. Hope it works for you.
Post #1491571
Posted Thursday, September 5, 2013 5:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 6,420, Visits: 13,810
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 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"
Post #1491718
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse