SQL Server and SSL Encryption - TechRepublic
General discussion
April 26, 2001 at 05:58 PM
rcwalters

SQL Server and SSL Encryption

by rcwalters . Updated 25 years, 2 months ago

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 .

This discussion is locked

All Comments