This lowered the security protocol to a lower state but were able to establish SQL Connectivity between the Application server and the Database Server, but still the Application initially couldn't connect. Microsoft added/enabled TLS 1.0 and TLS 1.1 to the Database Server for testing purposes only since Microsoft does not support TLS 1.0 anymore. Ok, so we worked with Microsoft Support on this issue and this is the understanding that we came to. I looked at the compatibility between the JDBC Version and the SQL Server matrix here and it looks like JDBC 4.0 works with SQL Server 2016.
Dbvisualizer view connection properties driver#
I looked at the following: SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryptionīut we cant seem to understand what is causing this issue since nothing on the Application Server has changed. There is no logon failure because we tested the application login and password and it worked fine. We did not touch the application server at all, expecting that when the database server is up, since it is the same servername, it would start back up fine, but the application is failing with the above error. Error: "SQL Server did not return a response. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. When we did the database server upgrade last time from SQL Server 2008 to SQL Server 2012, we followed the same method and the application worked fine.īut this time it is throwing the following error into the Application logs: : Could not create connection - nested throwable: (.SQLServerException: The database server has been recently upgraded(Side by side upgrade with the same servername as the one before that the application use to connect to) from Windows 2016 to Windows 2019 and SQL Server 2012 to SQL Server 2016 and there is no Java on this server.
Dbvisualizer view connection properties update#
Java Version on this Server is Version 6 Update 32. Java Based Application is running on Windows Server 2008 R2 Enterprise.
0 kommentar(er)
