SQL Server Linked servers can introduce a security risk if not configured properly. Some settings out of the box can make Linked Servers more secure, like using proper logins mappings. In this article, we look at how to enable encryption between linked servers.

Please read the latest MSSQLTips post: “SQL Server Linked Server Encryption for Network Traffic“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.