SQL Server 2005 Encrypted connection between client and server

[intrex]

Hello,

I am using a hosting service for sql 2005 server and a .net 2.0 web application. I am hoping to be able to send some of the data to the database from a remote location. This data is very sensitive so I need to be able to encrypt the connection between the remote server and the sql 2005 server. This sql server is hosted so I don't have administrative access. I have seen how to encrypt data that you put into the database but that is going to make my application a nightmare of extra code for encrypting and decrypting. The remote server is going to be connecting to the sql 2005 database via a .net 2.0 C# windows service. Is there anyway to encrypt the connection (other than IPSEC between servers or forcing all connections to the sql server to be encrypted?). Any ideas would be greatly appreciated.

 

[mrdenny]

From everything I've seen about setting up the encrypted connections you'll first need to have admin rights on the SQL Server because you will need to install a cert on the database server.

There is some data in BOL about setting up a secure connection.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[intrex]

Thanks for the reply. I have come to the same conclusion. Oh well back to the drawing board.