Forcing SQL Compare and SQL Data Compare to use an encrypted connection
Published 04 June 2013
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:
- Open SQL Compare or SQL Data Compare.
- Create a new project or edit an existing project.
- In the Data Sources tab, go to the Server field.
- Type or paste one of the following:
For a default instance:
<Server Name>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE
For a named instance:
<Server Name>\<Instance Name>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE
For a default instance not running on the default SQL port (1433):
<Server Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE
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.