PENDING SCCM Installation Error Failed to set up SQL Server certificate

[ammararif9]

Hi All, I have been having this problem for days now for SCCM installation. Can someone help me? This is the log

Create_BackupSQLCert : SQL server failed to backup cert. $$<Configuration Manager Setup><05-06-2019 04:09:43.983+00><thread=3516 (0xDBC)>
CSiteControlSetup::SetupCertificateForSSB : Failed to create/backup SQL SSB certificate. $$<Configuration Manager Setup><05-06-2019 04:09:43.983+00><thread=3516 (0xDBC)>
ERROR: Failed to set up SQL Server certificate for service broker on "WIN-IL12B56GG52.sccm.poc" . $$<Configuration Manager Setup><05-06-2019 04:09:43.983+00><thread=3516 (0xDBC)>
ERROR: Failed to initialize the site control data. $$<Configuration Manager Setup><05-06-2019 04:09:43.983+00><thread=3516 (0xDBC)>

 

[Jagadeesh7p]

Ammar - I'm also having same issue today while re-configuring the SQL for CM.. Please post the solution if you could have found it already. thank you.

 

[Jagadeesh7p]

Here is the Log:
INFO: SQL Connection succeeded. Connection: TEST.LOCAL CM_TS0, Type: Secure
*** SELECT dbo.fnConvertBinaryToBase64String(thumbprint) FROM master.sys.certificates WHERE name='ConfigMgrEndpointCert'
*** [42000][6263][Microsoft][SQL Server Native Client 11.0][SQL Server]Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
ERROR: SQL Server error: [42000][6263][Microsoft][SQL Server Native Client 11.0][SQL Server]Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
CSiteControlSetup::Create_BackupSQLCert : Failed to get SSB certificate thumbprint.
CSiteControlSetup::SetupCertificateForSSB : Failed to create/backup SQL SSB certificate.
ERROR: Failed to set up SQL Server certificate for service broker on replica node "SCCMSQLP01" .

 

[Garth]

https://www.enhansoft.com/how-do-i-enable-clr-within-sql-server/

 

[Jagadeesh7p]

https://www.enhansoft.com/how-do-i-enable-clr-within-sql-server/

Still same issue.. Garth

 

[Garth]

Still same issue.. Garth

then you need to call support as the error is clear and tells you exactly what to do to fix it. if the fix does not actually fix it then you have no other choice but contact css.

 

[mkleymann]

I'm having the same error as the original poster, running an update to SCCM 1902 from 1806:
Create_BackupSQLCert : Failed to execute spCreateAndBackupSQLCert CONFIGURATION_MANAGER_UPDATE 6/17/2019 4:43:26 PM 2552 (0x09F8)
CSiteControlSetup::SetupCertificateForSSB : Failed to create/backup SQL SSB certificate. CONFIGURATION_MANAGER_UPDATE 6/17/2019 4:43:26 PM 2552 (0x09F8)
ERROR: Failed to set up SQL Server certificate for service broker on "<myserver (SCCM, not remote SQL Server)>" . CONFIGURATION_MANAGER_UPDATE 6/17/2019 4:43:26 PM 2552 (0x09F8)
ERROR: Failed to initialize the site control data. CONFIGURATION_MANAGER_UPDATE 6/17/2019 4:43:26 PM 2552 (0x09F8)
InstallSystem failed. CONFIGURATION_MANAGER_UPDATE 6/17/2019 4:43:26 PM 2552 (0x09F8)

I mention the original poster, because the CLR issue previously noted does not appear in this log text.