title: SQL Server cannot find Certificate
body: <p>Background Information:</p>
  
  <p>I have a single Window VPS at example.com.
  I have it running IIS and SQL Server.
  I have a certificate for example.com that works fine with IIS.
  I want to use the same certificate for SQL Server to allow encrypted connections with clients.
  SQL Server Configuration Manager does not present the certificate in the drop down.</p>
  
  <p>I believe the problem is that SQL Server does not think the certificate is valid, because what SQL Server thinks the server name is does not match the certificate (example.com).</p>
  
  <p>How do I check what SQL Server thinks the server name is? If it is wrong how would I change it?</p>