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?