question

pGwtech avatar image
0 Votes"
pGwtech asked CarrinWu-MSFT commented

SQL Server certificate bindings lost

Hi there,

Experencing an issue with SQLServer certificate bindings are getting dropped.

Closest thread/article I could find with any valid leads was in the following article re: IIS, https://docs.microsoft.com/en-US/troubleshoot/iis/https-connections-fail-ssl-bindings-deleted

I couldn't find any related events in the EventViewer logs.
Anyone have any info on SQL Server losing certificate bindings?
It is difficult to monitor, since the regkey still persists when the binding is cleared, until the SQLServer service is restarted, but the reset state leave the service in a defunct state for API trying to interface such as PowerBIGateway, shows it as an expired certificate. The workaround is to rebind and restart the SQLServer service and it works.

Any guidance is appreciated, thanks.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @pGwtech,

Welcome to Microsoft Q&A!

Here has a thread may similar with yours, please try the solution as below:

1: Export the SSL certificate and key into a .pfx file
2: Un-bind the SSL certificate from the website
3: Delete the SSL certificate. I used MMC with the Certificates snap-in. I also deleted the default SSL certificate that gets automatically created during installation. The SSL cert with the "weird" name that you'll probably never use.
4: Import the SSL certificate from the .pfx file into the Local Computer Personal Certificates.
5: Bind the SSL certificate to the website.

If it's not work, please follow the troubleshooting steps to figure out this issue. This document will help you in troubleshooting SSL issues related to IIS only. But client certificates troubleshooting will not be covered in this document.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

pGwtech avatar image
0 Votes"
pGwtech answered CarrinWu-MSFT commented

Hi Carin,

Appreciate your response and while the workaround may potentially fix the issue, I am seeking a more SQL Server specific solution, given that I would need to send this to my Infrastructure team to perform the export since our Certificates are password protected and further, these Certificates are valid and working across our other servers and applications.

Regards,
Pierson

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @pGwtech, good to know that your issue has been resolved! If there has any other issues, please feel free to let us know.

0 Votes 0 ·