Secure Connection to SQL Server 2000 Database

[AF]

I am looking for the options in securing this connection.

First option tried

A certificate was installed on the remote server and the option "encrypt=true" added to the connection string, but still getting an SSL error (works without the encrypt option). What else must be configured for this to work properly? Is this the most straightforward way to encrypt all data to and from the webserver?

Any help or examples would be appreciated

Thank you
A

Environmen

Web Server:
Windows 2k Serve
IIS
ASP.NET Web Applicatio

Database Serve
Windows 2k Serve
SQL Server 200