Enable SSL Encryption for SQL Server
Check out Knowledgebase Articles from Microsoft to enable SSL Encryption between SQL Server and Client. The communication can be encrypted between SQL Server and all the clients by forcing the encryption at the server side, while you can encrypt communication between SQL Server and specific client by forcing encryption at the specific client. Please note that this requires considerable background on PKI Infrastructure.
See Microsoft Knowledge Base Article 276553
Q276553: HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate Server
See Microsoft Knowledge Base Article 316898
Q316898: Enable SSL Encryption for SQL Server 2000 with Microsoft Management Console