August 16, 2016 at 1:08 pm
Hello,
I'm currently testing the new ODBC version 13 driver. I'm running SQL Server 2008R2 on Server 2012. Because I'm not using SQL Server 2016 I know I'm not able to utilize the always on encryption. But when I test my connection string I get results of:
Microsoft ODBC Driver for SQL Server Version 13.00.0811
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
INFO: Data encryption was enforced by server or client machine-wide setting.
INFO: Connection was encrypted without server certificate validation.
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
[/Quote]
Is my connection encrypted? Even though encrypted columns are being transferred in plan text within the connection.
August 16, 2016 at 2:07 pm
I think that message is not directly related to "always on encryption".
Microsoft SQL Server Native Client Version 11.00.2100
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
INFO: Data encryption was enforced by server or client machine-wide setting.
INFO: Connection was encrypted without server certificate validation.
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
Note that this message will show up if on the properties of the network protocol for your instance force encryption is set to yes
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply