SQL Data Compare 14

How to force SQL Compare and SQL Data Compare to use an encrypted connection

By default SQL Compare and SQL Data Compare do not have an option that forces the use of an encrypted connection when connecting to databases.

The work around is to specify the force encryption properties into the SQL Compare or SQL Data Compare connection string.

  1. Start up SQL Compare or SQL Data Compare.
  2. Create a new project or edit an existing project.
  3. Go to Project Configuration -> Data Sources.
  4. 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
    If server is not running on the default SQL Port 1433:<Server Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE or <Server Name>\<Instance Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE

Didn't find what you were looking for?