Microsoft has released an article that tells you how to establish and enforce encrypted multiprotocol connections in SQL Server 2000. When you connect to an instance of SQL Server 2000, you can use Secure Sockets Layer (SSL) encryption or multiprotocol encryption to encrypt the data that's transmitted between the server computer and the client computer. The Microsoft article describes how to enable multiprotocol encryption for all the client connections, for a specific client, over a firewall, over TCP/IP, and over named pipes. To learn more, read the Microsoft article "How to establish and enforce encrypted multiprotocol connections in SQL Server 2000" at<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

   http://support.microsoft.com/?kbid=841695