Re: securing connection between web site and SQL server


"rb0404" <rb0404@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F0AAB88-98D0-43EA-918C-4A6B35054C9D@xxxxxxxxxxxxxxxx
I am using SQL server 2000. The option you suggest doesn't seem to be
available in this version. I've tried generating a certificate through IIS
and authorising it using certificate authority and installing it. However,
when I try and set up an ODBC connection with strong encryption from a
machine that is outside our firewall it fails (it works with the strong
encryption unticked). Any more ideas would be appreciated thanks

Is it possibly an issue at the firewall then? Without knowing your
configuration it's hard to guess at the problem. Check your configuration
in the Client Network Utility and Server Network Utility.

http://msdn2.microsoft.com/en-us/library/aa213770(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa174508(SQL.80).aspx



.