SQL Compare 15

Forcing SQL Compare and SQL Data Compare to use an encrypted connection

Info

From version 15.0.2.22953 checkboxes for "ENCRYPT" and "TRUSTSERVERCERTIFICATE" have been introduced into the UI

By default, SQL Compare and SQL Data Compare don't have an option to force an encrypted connection when connecting to live databases.

To force an encrypted connection, you can add the encryption properties into the SQL Compare or SQL Data Compare connection string:

  1. Open SQL Compare or SQL Data Compare.
  2. Create a new project or edit an existing project.
  3. In the Data Sources tab, go to the Server field.
  4. Type or paste one of the following:
    1. For a default instance:

      <Server Name>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE
    2. For a named instance:

      <Server Name>\<Instance Name>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE
    3. For a default instance not running on the default SQL port (1433):

      <Server Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE
    4. For a named instance not running on the default SQL port (1433):

      <Server Name>\<Instance Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE

SQL Compare or SQL Data Compare will now use an encrypted connection.


Didn't find what you were looking for?