Is the data transferred between two linked 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 linked server to another is secure? I have tried researching the subject but am unable to find anything.
Many thanks, Sebastian