Hi All,

I am Seeing below error message getting logged in SQL logs. Application team was not able to connect to the server due to this issue, when we checked if there was any change that was made on server which is causing this was able to find below details.We had to disable the SSL encryption after which application team was able to connect to the SQL instance.

Service pack 2 was applied to SQL server 2012 instance the same day. when looked at details there were around 12 instances running on a two node cluster and the instance which was having issues and other instance were patched with sp2.

Could some one please confirm if we update the SQL instance with SP2 then would there be need to update any drivers in this sort of scenarios when SSL is configured for SQL servers.

Error Message getting logged in SQL logs

Logon Error: 17835, Severity: 20, State: 1.Logon Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library.

• Edited by Kranthi_06 15 hours 26 minutes ago

Hi, take a look here

https://technet.microsoft.com/en-us/library/ms191192%28v=sql.120%29.aspx

Hope will help you

Regards

Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library. 

Hello,

This can have at least 2 reason:

- The required certificate for SSL encyption is not installed on the Client machine

- The application indeed uses an outdated data provider or one that don't support encyption