It is likely that the issue has to do with extremely outdated security providers, that are no longer supported. This will very likely solve the issue, but is most definitely not recommended. This could work but there is no guarantee.Īlso another thing to note is that SQL Server 20R2 are out of support, so the oldest we could go (and still stay supported) would be SQL Server 2012 which may not resolve the issue.Ģ.Open the security wide open. If you don't have the resources to the application then the options are these:ġ.Rollback to older Servers for SQL Server. So the recommended solutions if you have the resources to modify the application, are to update the drivers for the application, test and redeploy. In our case, the application did connect after enabling the TLS 1.0 and TLS 1.1 after sometime. Microsoft thinks that it is because of the current connection provider/driver that is being used by the application and they wouldn't support that part of it since that is Java/Oracle's JDBC driver. 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. 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. Java Version on this Server is Version 6 Update 32. Java Based Application is running on Windows Server 2008 R2 Enterprise.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |