SQLServer Encryption Of Data Channel From C#

Question

Can anyone give me pointers on how to achieve the above - I am familiar with the C# libraries and database connectivity but have never had to use a secure channel.

What do I need to do in C# and on the database side to force connections to always be encrypted??

Answer 1

See this Microsoft KB for details on how to do this.

Answer 2

A reliable way to secure communication without SSL certs between a web server and SQL Server machine is to use IPSec.

http://msdn.microsoft.com/en-us/library/aa302366.aspx