SSL Certificate: Configuration problem after selfssl and multiple cn

• Collateral

  SSC Enthusiast

  Points: 185

  More actions

  May 13, 2009 at 2:03 am

  #155696

  Hello,

  i have a problem with a SSL certificate. I have an ASP Website on IIS6 which uses a SQL Server 2005 as database.

  I created a new SSL certificate (with selfssl.exe). After that, I booted the Server, then I assigned the new certificate

  to the SQL Server (Configuration Manager -> Network Configuration -> Protocols -> Properties -> Cerficates)

  So far, so good.

  If I use this certifcate:

  "C:\Programme\IIS Resources\SELFSSL\"selfssl.exe /T /V:50002 /N:cn="SERVER"

  where "Server" is the name of my Server, all works well.

  But if I want to add another common name (CN) to the certificate, like this:

  "C:\Programme\IIS Resources\SELFSSL\"selfssl.exe /T /V:50002 /N:cn="CSERVER2",cn="localhost"

  the generated certificate is not shown in the list in the configuration manager. Without the certificate I cannot

  connect with the SQL Server.

  Has anyone ideas why the new certificate (with multiple common names) is not shown in the list?

  By the way, I don't want to use SSL for my connection to the SQL Server. Is there a possibility to deactivate it,

  so the SQL Server doesn't need the certificate at all?

  Thanks