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.
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.