Unable to load user-specified certificate in event log although SSL certificate is installed
0
votes
1
answer
3686
views
>Unable to load user-specified certificate [Cert Hash(sha1) "SOMERANDOMHASH"]. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.
I am getting this error even though it's installed.
https://support.dh2i.com/docs/kbs/dxenterprise/configure-ssl-certificates-for-microsoft-sql-server-with-dxenterprise/
I even followed both methods to install it, one through pfx and the other with snap-in, and then modified the regedit entry before restarting MSSQL through the SQL Server Configuration Manager, but it won't restart. Is there a reason for this and are there ways to investigate what's going on? I installed on production, but it doesn't work on the staging environment.
Asked by user253549
Mar 10, 2022, 08:55 PM
Last activity: Aug 2, 2025, 02:03 PM
Last activity: Aug 2, 2025, 02:03 PM