RE: SSL on published SQL Server

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 01/27/04


Date: Tue, 27 Jan 2004 21:39:37 GMT

You'll need a cert issued to the FQDN installed on the SQL Server, and the
same cert would need to be installed on the ISA box.
Once you put the cert on the server and enable Force Protocol Encryption
using the Server Network Utility, the MSSQLServer service needs to be
restarted. We only read the cert once on startup. If the server fails to
start, there is a problem with the cert.

Verify that you can make SSL connections from a client inside the firewall
first.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.