I have recently installed an ssl certificate on SQL Server in our office with the intent of encrypting connections between clients and the server. I was able to import the cert/key pair just fine into Windows (under the Local Computer certificate store, using the standard Certificates MMC). However, the cert does not show up in the SQL Server Configuration Manager when opening the 'Properties' -> 'Certificate' tab under 'Protocols for MSSQLSERVER'.
I have been do some searching around the web, and everything I've found suggests this is due to the cert being invalid in some way. However, I have verified just about everything I can about the cert:
It is issued to the proper FQDN of the server.
I have the private key installed.
It has the Server Authentication role.
All CAs in the cert chain are trusted.
The Certificates MMC shows it as being valid.
What is the magic requirement for SQL Server 2008 to accept this cert? As a test, I was able to configure other services (such as IIS) to use the cert successfully, so I'm fairly certain the cert is good.