MS SQL Server 2005 with SSL problem

Discussion in 'Database Support' started by SubSpace, Oct 23, 2007.

  1. SubSpace

    SubSpace Bass

    I'm trying to get SSL to work on a SQL Server 2005 installation, but I'm getting the following error message when I try to connect:
    "SQL Server Certificate chain was issued by an authority that is not trusted".

    It doesn't make much sense though, the certificate I'm using is issued by Equifax, which is definitely in the root certificate list.

    I'm using the same certificate without problems on IIS. It's a wildcard certificate and for a while I thought that was the problem, because initially the error message was "The certificate's CN name does not match the passed value". That message was however replaced with the above one with actually anything changing..

    Any ideas anyone?
  2. Stephen

    Stephen US Operations Staff Member

    can you open the certificate store on MSC and check that the equifax root cert is not expired? I have seen this happen before, you have to download the new root certs from windows update.
  3. SubSpace

    SubSpace Bass

    Certificate expires in 2018, I checked that :)

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services