Unable to load user-specified certificate [Cert Hash(sha1) “”]. The server will not accept a connection. You should verify that the certificate is correctly installed. See “Configuring Certificate for Use by SSL”

We recently ran into below issue trying to change the SQL Server Service Account. SQL Server Service was running under local service account and the instance is configured for force encryption with certificate. Issue :¬†Unable to load user-specified certificate [Cert Hash(sha1) “XXXXXXXXXXXXXXXXXXX”]. The server will not accept a connection. You should verify that the certificate […]