locked
Wildcard certificate in mssql 2008R2 RRS feed

  • Question

  • Hello, 

    I have installed wildcard certificate in Certificates(Local Computer)\Personal in  sql server. We are using Windows 2008R2 server and 2008 R2 SQL server. Certificate is issued by StartCom. With certificate everything is ok (I have used it in IIS), but it didnt appeared in sql configuration manager protocols dropdown list. So i followed microsoft article:

    http://support2.microsoft.com/kb/316898

    and added certificate thumbrint in registry. Restarted SQL service.

    Then I am trying to connect to sql server using SMSS I am getting error:

    "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate's CN name does not match the passed value.) (Microsoft SQL Server, Error: -2146762481)"

    So obviously problem is wildcard certificate, because it is issued to *.domain.com and server name is server.domain.com.

    By this article, microsoft sais that "SQL Server 2008 R2 and the SQL Server 2008 R2 Native Client support wildcard certificates. "

    http://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx

    So question would be: Sql 2008 r2 supports or does not support wildcard certificates. If supports, so there is problem? Why i am getting this error?


    Mantas

    Monday, November 10, 2014 9:26 AM

Answers