After migrating 10.0 FP 2208 can not connect with Jasper Reports.

[gonzalogomez]

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

[Johan_H]

Perhaps Jasper Reports also needs to be upgraded. You should ask Jaspersoft support about this.

[gonzalogomez · Accepted solution]

After try multiple drivers to connect to sql2016...

I found one that worked (mssql-jdbc-7.0.0.jre8.jar)

[gonzalogomez]

with other programs and/or applications it continues to work without incident, it has only stopped working with sql when migrating from 9.3 to 10.0... could it be a coincidence?