SSMS Integration pack and encrypted connections
mdefehr
Posts: 5
I am required to use encrypted connections to certain servers. I have set them up appropriately in the SSMS "Registered Servers" section and have verified that object explorer nodes and any query windows that spawn from those connections are all encrypted.
When I use the SSMS integration pack to define databases to compare within these connections, however, the connection that SQL Compare makes when doing the comparison is not encrypted. One might expect that when SQL Compare bases it's connection on an SSMS connection, that an important attribute like this might come along.
I understand that to encrypt the connection, you have to add ";ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=FALSE" to the server name in the SQL Compare UI (which is kind of cryptic, by the way - no pun really intended) but (a) I would have hoped not to have to worry about that since the connection it is base on is encrypted, and (b) it might be surprising/alarming to some that it is not encrypted.
Is it a big deal to bring the encryption attribute along for the ride when the integration pack fires up Compare?
Thanks,
MDD
When I use the SSMS integration pack to define databases to compare within these connections, however, the connection that SQL Compare makes when doing the comparison is not encrypted. One might expect that when SQL Compare bases it's connection on an SSMS connection, that an important attribute like this might come along.
I understand that to encrypt the connection, you have to add ";ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=FALSE" to the server name in the SQL Compare UI (which is kind of cryptic, by the way - no pun really intended) but (a) I would have hoped not to have to worry about that since the connection it is base on is encrypted, and (b) it might be surprising/alarming to some that it is not encrypted.
Is it a big deal to bring the encryption attribute along for the ride when the integration pack fires up Compare?
Thanks,
MDD
Comments
It does seem like a resonable feature request to make, so I've added a job for it, and it'll get reviewed for possible inclusion in a future release.
Redgate Software