I have SQL Server 2000 running on NT4.0 Server SP6a. I installed Certificate Server from the NT Option Pack.
I want to talk ODBC from clients to the server, encrypted with SSL. Supposedly this is supported by checking the Force Protocol Encryption option on SQL Server. My problem is, when I do that, the SQL service will not start–the error is something to the effect of, “Encryption requested but cannot find valid certificate. ” Why the heck can’t it find a valid certificate? I also have IIS 4.0 on this same machine, went through all the Technets on how to assign a certificate to IIS, and it works great from browser-to-webserver. SQL Server just doesn’t see a valid certificate .