Why have all my SQL Compare project changed to ENCRYPT connections

jimVisage1980

Just upgraded from SQL Compare 14 to 15.
I thought, great all My Projects are still all visible when I run version 15.
Tried to run one and connection failed. On opening I find that both connections now have the Encrypt option ticked.
On checking I find that all my projects have defaulted to Encrypt option ticked for both connections!  Great if your servers are configured for encrypted connections.

This is not great Redgate.

Any way to change so all my projects are back to non-encrypted connections without having to manually edit all the projects?

p.s.
SQL Data Compare has the same problem too.

DanC

Hi @jimVisage1980

This was due to a recent change by Microsoft in which the Microsoft.Data.SqlClient now encrypts connections by default and requires a certificate to be present, or have trust server certificate enabled

The comparison tools were updated to reflect the update from Microsoft.

If you open the project, you can enable trust server certificate: 

jimVisage1980

I think you are missing the point I made.
When I upgraded from 14 to 15 all my projects should have been left in the same state. 

Now I either have to untick the 'Encrypt' box or tick the 'Trust server certificate'  box (for both connections) for all of my pre-existing projects in order to do a compare.

DanC

Hi @jimVisage1980

Apologies, I overlooked that part of your issue, I've just tested this myself and it does indeed seem to change the existing projects to have 'Encrypt' enabled. 

I can only assume this is due to reflect Microsoft's stance on the default behavior and I can only apologize for the inconvenience this has had on your existing projects

jkwraase

Is there a way to set the "Trust server certificate" checkbox ON by default?

DanC

Hi @jkwraase

I did check with the team, but apparently there's not a registry key available for performing this, so you'll need to manually tick it 

MikePendleton

Any update on when this is going to be fixed.  You get the same issue when use the SQL Server plugin context menu option to SQL Compare/Data Compare by right clicking on the database in the Object Explorer.  All other database connection properties (server/database/user info) are transferred to SQL Compare, but not these checkboxes.  Highly annoying.  

DanC

Hi @MikePendleton

Unfortunately, you will need to tick Trust Server Certificate when opening SQL Compare, I would advise saving connects to a project to speed up this process