SCCM console open error and link failed with SQL Server Native Client 11.0]SSL Provider: The received certificate has expired

 Hello Admins!!

Today I was not able to open SCCM console with error and also CAS to problematic Primary was failed in replication. When checked, port 1433 to SCCM database of site where I opened the console, its was opened. So, next I checked admin console log and just found "Provider failure" error. Nothing much. Then I checked sms provider log on server and found below.

SQL Server Native Client 11.0]SSL Provider: The received certificate has expired 

This made me to check the SQL server self sign certificate on SCCM database server (now it can be on same server where you have your site server or it can be on different box). I found certificate present and active (not expired). Then where is the problem ? I thought to check SQL server configuration for this certificate, so I opened SQL server configuration manager console.

I browsed to SQL Server Network Configuration > Protocols for MSSQLServer and right click it to check "Certificate" tab. Guess what !! the SQL Server self-sign certificate mapping is lost. So, I click drop down button against Certificate and select the present SQL Server self-sign certificate and click Apply.

After mapping:

After that, I restarted SQL server service on database box. I checked console opening, it opened and after 10-15 minutes, I found replication was active. Issue fixed!!

Note: In some case, you may find same certificate is expired. In such case you need to create fresh self-sign certificate and map to this same location and restart the SQL server service to see the change. 

Hope, you have liked this post and may help you to troubleshoot and fix the issue if you may encounter this error.

Read More