I installed a SSL certificate using a pfx file, taking the hash and putting it inside the certificate key of SuperSocketNetLib, I restarted the MSSQL server using the MSSQL Management Tool, and upon doing that I got the following errors:
The SQL Server (MSSQLSERVER) service terminated with the following service-specific error: Cannot find object or property. A fatal error occurred when attempting to access the TLS server credential private key. The error code returned from the cryptographic module is 0x8009030D. The internal error state is 10001. SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the operating system error log for information about possible related problems.
I could not restart the server. Strangely enough, I went to a dev server and did the same thing and I didn't get any error. So the certificate works in one machine, but not the other, and I was able to connect with the encryption option checked.
To restart the server on the other machine, I had to use the old certificate hash inside the certificate key of SuperSocketNetLib, which means it's something wrong with the certificate, but what is wrong and why is it working on other sites? The SSL and pfx files worked on other website. It's a certificate for *.netflix.com and I was able to install it on multiple IIS server such as finance.netflix.com, acc.netflix.com using the pfx file and multiple websites.