This post originated from an RSS feed registered with .NET Buzz by Pau Laudeman. Original Post: Enabling SSL encryption with SQL Server 2000 Feed Title: Paul Laudeman Feed URL: /error.htm?aspxerrorpath=/blogs/paul.laudeman/rss.aspx Feed Description: Helping You to Make "Smart Clients" Smarter! Latest .NET Buzz Posts Latest .NET Buzz Posts by Pau Laudeman Latest Posts From Paul Laudeman

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:

• How To: Use SSL to Secure Communication with SQL Server 2000
• How To: Enable SSL Encryption for SQL Server 2000 with Certificate Server
• How To: Enable SSL encryption for SQL Server 2000 with Microsoft Management Console

If SSL isn't an option for you, see also:

• How To: Use IPSec to Provide Secure Communication Between Two Servers