splattne Asked: 2009-05-01 02:50:10 +0800 CST2009-05-01 02:50:10 +0800 CST 2009-05-01 02:50:10 +0800 CST How to enable encrypted connections to a SQL Server instance? 772 How can I enable an encrypted network connection to SQL Server? What have I to do on the client and on the server side? sql-server security encryption 2 Answers Voted Best Answer K. Brian Kelley 2009-05-01T03:42:24+08:002009-05-01T03:42:24+08:00 You can let the operating system take care of it via an IPSEC policy. With SQL Server, you must have a trusted SSL certificate, but here's how: Books Online - How to: Enable Encrypted Connections to the Database Engine. nedm 2009-05-09T15:57:32+08:002009-05-09T15:57:32+08:00 You can configure via server/client network utilities: http://support.microsoft.com/kb/316898 You still need certificates, and to specify encryption in the connection string. We use an offline CA to generate our certificates using OpenSSL, and then install on the clients and server w/ MMC.
You can let the operating system take care of it via an IPSEC policy. With SQL Server, you must have a trusted SSL certificate, but here's how: Books Online - How to: Enable Encrypted Connections to the Database Engine.
You can configure via server/client network utilities: http://support.microsoft.com/kb/316898
You still need certificates, and to specify encryption in the connection string. We use an offline CA to generate our certificates using OpenSSL, and then install on the clients and server w/ MMC.