We've purchased an SSL certificate for our Server with a specific CN and implemented the certificate on IIS.
We imported the same certificate on the SQL Server machine.
However, when trying to configure the instance from configuration manager there is certificate showing up in certificate tab.
With reference to link for deploying and troubleshooting certificate: http://support.microsoft.com/kb/316898/
Apparently the certificate was not issued to the machine FQDN/hostname as there is no domain for the SQL Server machine or the Web Server machine.
I tried creating an OpenSSL certificate on a machine using its hostname but when trying SCM to configure the instance after certification deployment there's no certificate in the tab.
Does an OpenSSL certificate or a purchased certificate use port 443? Reference this link: https://stackoverflow.com/questions/9342769/sql-server-cannot-find-certificate.
If yes, what is the GUID for my SQL Server instance or where can I get this info while running "netsh".
Above link also states.
“The last step was making sure the account running SQL Server had permission to read the certificate. I went into the certificate snap-in and then went to properties under the certificate, then on the Security tab I gave the Network Services account read permission on the certificate. (NOTE: I did not find any tutorials online reference this step. I was just some dumb luck that I found this.”
I couldn't find any security tab; is there something other than the MMC wizard to see this property of certificate?
Window Server 2008 R2 SQL Server 2008 Web Edition
What am I missing?