Hello
I have setup a connection to my SQL Azure database in the dbForge SQL Server Schema Compare connection manager, but the connection string shown does not include "Encrypt=True".
I appreciate the SQL Azures forces connection encryption, however best practice indicates "Encrypt=True" and "TrustServerCertificate=False" should still be used in the connection string as outlined here: http://blogs.msdn.com/b/buckwoody/archi ... -true.aspx and http://msdn.microsoft.com/en-us/library ... 94108.aspx
1) Does the dbForge append these parameters to the connection string shown or can I make it add them?
2) If "Encrypt=True" is not specified, can my SQL Azure credentials ever (even the remotest possibility) be sent over an unencrypted connection (presumably an unencrypted connection is, or may be, attempted first before SQL Azure forces the use of an encrypted connection)?
Thank you
SQL Azure Encrypt Connection String
-
alexa
Re: SQL Azure Encrypt Connection String
dbForge Schema Compare for SQL Server does not add any parameters to the connection string.1) Does the dbForge append these parameters to the connection string shown or can I make it add them?
Since SQL Azure forces connection encryption, SQL Azure credentials always go through an encrypted connection.2) If "Encrypt=True" is not specified, can my SQL Azure credentials ever (even the remotest possibility) be sent over an unencrypted connection (presumably an unencrypted connection is, or may be, attempted first before SQL Azure forces the use of an encrypted connection)?