Microsoft has several articles (see below) on how to enable SSL communication with SQL Server 2000. This is useful to do if you want to ensure that the communication to your database server is encrypted and cannot be snooped with packet sniffers.
If you are running SQL Server as a limited privilege domain account you’ll need to perform an extra steps to get everything to work. If you don’t, your likely to get several error messages posted to your event log and SQL Server will not be able to run in encrypted communication mode.
On your SQL Server, you must grant the SQL Server service account Full Control permissions to the following directory:
C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto
After assigning the new permissions, be sure to check the Replace permission entries on all child objects with entries shown here that apply to child objects option.
For more information about how to set up SSL with SQL Server, see the following KB articles:
If SSL isn't an option for you, see also:
Technorati Tags: sqlserver 2000, sqlserver ipsec