Yellowfin unable to connect to the SQL Server running under ForceEncryption
3 August, 2015
Environment details.
Host Operation System : Window 2012 64 bit Operation System.
Yellowfin Version: Yellowfin 7.1
JDK Verison : Java 1.8 (customer had to migrate to this JDK because of their Security regulations, this cannot be reverted).
SQL Server : SQLServer 2012 (running on ForceEncryption), refer to the below screenshot for more details.

While connecting to the SQLServer the following error is getting reported in the JDBC log
2015-07-31 19:26:30 NOTICE: 2015-07-31 19:26:30
2015-07-31 19:26:30 NOTICE: Starting DBConnectionPool
2015-07-31 19:26:30 NOTICE: sourceId: 0
2015-07-31 19:26:30 NOTICE: sourceName: Application Configuration Database
2015-07-31 19:26:30 NOTICE: connectionMethod: JDBC
2015-07-31 19:26:30 NOTICE: authAdapter: Standard Authentication(GENERICUSER)
2015-07-31 19:26:30 NOTICE: driver: net.sourceforge.jtds.jdbc.Driver
2015-07-31 19:26:30 NOTICE: url: jdbc:jtds:sqlserver://localhost:1433/safereports71
2015-07-31 19:26:30 NOTICE: username: sa
2015-07-31 19:26:30 NOTICE: min connections: 2
2015-07-31 19:26:30 NOTICE: max connections: 25
2015-07-31 19:26:30 NOTICE: maxOpenTime: 4 h
2015-07-31 19:26:30 NOTICE: maxCheckoutTime: 5 min
2015-07-31 19:26:30 NOTICE: psCacheSize: 20
2015-07-31 19:26:30 NOTICE: FetchSize: 0
2015-07-31 19:26:30 NOTICE: Verify connections: false
2015-07-31 19:26:30 NOTICE: Application Version: 7.1
2015-07-31 19:26:30 NOTICE: Build Version: 20140923
2015-07-31 19:26:30 NOTICE: Pooling Enabled: true
2015-07-31 19:26:30 NOTICE: -----------------------------------------
2015-07-31 19:26:30 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 1). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
2015-07-31 19:26:45 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 2). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
2015-07-31 19:27:00 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 3). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
2015-07-31 19:27:15 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 4). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
2015-07-31 19:27:30 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 5). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
Doing some research we found that the problem can be solved by following the steps mentioned in (http://stackoverflow.com/questions/11497530/jdbc-jtds-sql-server-connection-closed-after-ssl-authentication).
All the steps works fine, as long as we are working on JRE7, the moment we change the JRE version from 7 to 8 the following error gets reported in the JDBC log
2015-07-31 19:33:04 NOTICE: 2015-07-31 19:33:04
2015-07-31 19:33:04 NOTICE: Starting DBConnectionPool
2015-07-31 19:33:04 NOTICE: sourceId: 0
2015-07-31 19:33:04 NOTICE: sourceName: Application Configuration Database
2015-07-31 19:33:04 NOTICE: connectionMethod: JDBC
2015-07-31 19:33:04 NOTICE: authAdapter: Standard Authentication(GENERICUSER)
2015-07-31 19:33:04 NOTICE: driver: net.sourceforge.jtds.jdbc.Driver
2015-07-31 19:33:04 NOTICE: url: jdbc:jtds:sqlserver://localhost:1433/safereports71;ssl=require
2015-07-31 19:33:04 NOTICE: username: sa
2015-07-31 19:33:04 NOTICE: min connections: 2
2015-07-31 19:33:04 NOTICE: max connections: 25
2015-07-31 19:33:04 NOTICE: maxOpenTime: 4 h
2015-07-31 19:33:04 NOTICE: maxCheckoutTime: 5 min
2015-07-31 19:33:04 NOTICE: psCacheSize: 20
2015-07-31 19:33:04 NOTICE: FetchSize: 0
2015-07-31 19:33:04 NOTICE: Verify connections: false
2015-07-31 19:33:04 NOTICE: Application Version: 7.1
2015-07-31 19:33:04 NOTICE: Build Version: 20140923
2015-07-31 19:33:04 NOTICE: Pooling Enabled: true
2015-07-31 19:33:04 NOTICE: -----------------------------------------
2015-07-31 19:34:54 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 1). Will try again in 15 seconds. java.sql.SQLException: Network error IOException: Connection reset
request to provide a solution with JRE8 as our customer cannot revert back to JRE7 because of security policies.
Thanks
Nitin
We are experiencing the same problem... I would be interested to see the resolution to this issue?
Brad
we further referenced this url -
http://sourceforge.net/p/jtds/bugs/725/
Thanks
Nitin
Have you tried using the Microsoft JDBC driver?
Microsoft JDBC Driver for SQL Server
I know this has helped in the past with similar issues.
Regards,
David