MS SQL Server 2005 with SSL problem

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?
 
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.
 
Back
Top