December 3, 2018 at 7:28 pm
Hi,
I just wanted to post the problem I discovered with a recent KB that Microsoft put out. KB4467697 was installed on our SQL servers and now my ODBC and Cold fusion data sources no longer work. The Server is Windows 2012 and SQL is 2014. Once the KB is installed when trying to connect I get an SSL error similar to the one below. The only way to fix it is to uninstall the patch and reboot the server. The ODBC connection can be on the same server or on a different server or workstation. The worst part is after uninstalling the patch the reboot take a very long time for some reason.
Let me know if you have any thoughts or questions.
Connection failed
SQLState: '01000'
SQL Server Error:1
[Microsoft][ODBC SQL Server Driver][DBMSLPCN][ConnectionOpen
(SECCreateCredentials()).
Connection failed:
SQL Seate: '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][DBMSLPCN] SSL Security error
Jeff
December 4, 2018 at 9:31 pm
I had 2 similar issues with that patch. I found adding KB3102436, an upgrade to .NET Framework 4.6.1 corrected first issue. This issue was for connections using ADO.NET. Figured that out by reading this.
https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server
Second issue was for connections using the old builtin SQLODBC drivers. Could not find a patch or solution around this issue. Had to uninstall the patch from both server AND client. Advised others to switch to SQL Native Client or the newer SQL ODBC driver and where that wasn't possible we uninstalled the patch.
December 5, 2018 at 7:06 am
Good to know.
I might consider updating all our SQL Servers and clients computer to the newest SQL Drivers in my environment.
Jeff
January 3, 2019 at 5:20 pm
To deal with the patch We have update the odbc drivers to 17 the most current one and have been replacing all the odbc connections. The cold fusion data sources are still failing and I am workings with the developers to fix.
Jeff
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply