Category: How do I?
Date: 31 Oct 2009
Product: SQL Compare
Affected Products and Versions:
SQL Compare V3 and later.
SQL Data Compare V3 and later.

By default SQL Compare and SQL Data Compare do not have an option that forces the use an Encrypted Connection, when connecting to Data Sources that are live databases.

The work around is to specify the force encryption properties into the SQL Compare or SQL Data Compare connection string.
Start up SQL Compare or SQL Data Compare.
Create a new project or edit an existing project.
Project Configuration - Data Sources Tab.
Enter the server name, and enter the following after the server to force an encrypted connection:
For a Default Instance: 
<Server Name>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE 
For a Named Instance 
<Server Name>\<Instance Name>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE 
Or if server is not running on the default SQL Port 1433, 
<Server Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE 
<Server Name>\<Instance Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE