on 02-15-2024 10:22 AM
Hi all,
We had Jasper Reports running correctly. After migrating to version 10.0 and the security changes in the SQL that this version produces, we were unable to connect to said report generator.
This is the error:
"com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server with Secure Sockets Layer (SSL) encryption. Error: "No appropriate protocol (protocol is disabled or cipher suites are inappropriate)."
The Driver and the JDBC url is the same:
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://192.168.Y.XXX:1433;databaseName=TEST
It is evident that something has been activated or deactivated in the database in the sql that denies or rejects the connection.
Thanks in advance
After try multiple drivers to connect to sql2016...
I found one that worked (mssql-jdbc-7.0.0.jre8.jar)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
9 | |
5 | |
3 | |
3 | |
2 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.