Hey All,
I've been tearing my hair out over this. I have a single site MEM (2002), single local DB (SQL 2016). During the install I pass all the pre-reqs during the pre-req phase, and begin the install. But, it fails stating:
Failed to execute [SELECT Value1 FROM SC_SiteDefinition_Property WHERE SiteNumber=dbo.fnGetSiteNumber() AND Name=N'SiteExchangeCertificate']
Configuration Manager Setup
9/21/2020 4:32:28 PM 9624 (0x2598)
Failed to validate if site exchange certificate is already created.
Configuration Manager Setup 9/21/2020 4:32:28 PM
9624 (0x2598)
Failed to read public key from site Exchange certificate 87d20003
Configuration Manager Setup 9/21/2020 4:32:28 PM
9624 (0x2598)
Failed to set security descriptor (0x80070005)
Configuration Manager Setup 9/21/2020 4:32:28 PM
9624 (0x2598)
Failed to grant access to user ($domain\$sqlserviceaccount) (0x80070005)
Configuration Manager Setup 9/21/2020 4:32:28 PM
9624 (0x2598)
I've given the $sqlservice account full admin, and cleared the SMS keys, and double checked my RSA/MachineKeys Folder permissions. The SQL Service Account also has full sysadmin / dbo owner of the CM_$Sitename I created. I also attempted to not
pre-create the DB, but that still gives the same exact error.
I've been working with MS Premier Support but they have no clue whats going on. Any ideas?
