Secure communication between linked SQL Servers

Question

Is the data transferred between two SQL Servers protected (encrypted) by default? If not, is there a way to accomplish this?

I have two SQL Server 2005 databases running on separate servers, separate machines, separate networks. How can I ensure that data transmitted from one server to another is secure? I have tried researching the subject but am unable to find anything.

Many thanks, Sebastian

Answer 1

At a simple level the just ensure that the communication takes place over a HTTPS link. Then you can use x509 certs to secure the comms.

See SF for info on encryption on the linked servers

Answer 2

Thanks Preet! You pointed me in the right direction with that posting on ServerFault. Thank you!