Cannot connect to SQL 2014 DB with TLS1.2

Hi,

Our product uses BOXI 4.2 SP5 for its reporting and we have Error IES 10901 (the driver could not establish a secure connection to SQL Server using SSL encryption)

Our system looks like this.
a) RHEL Web Application Server using WebSphere 8.5.5.9
b) Windows SQL Server 2014
c) RHEL BOXI 4.2 Server

for (a) we had to add in addition connection string information to connect to the SQL Server into the WebSphere configuration, also the same for the connection to the other database on the same server.

Given that we had to do that for the WebApplication Server, I am assuming that the same has to be done for the BOXI Server ?

If so… where do we configure it ?

We have BOXI Tools installed on the SQL Server and have edited the universe connection to point at the SQL Server and DB, the connection test worked.
Where is this test being carried out from ?
Is it directly on the SQL Server via the BOXI Tools ?

Or does it simulate a connection from the BOXI Server ? I am suspecting its just testing that we can connect to the SQL Server DB from the tools.

Thanks in advance for any help here.


stevem :uk: (BOB member since 2008-10-27)

Check your driver files. We had to update our driver files for SQL Native Client 11 as there had been new drivers released that support TLS1.2. That was all we had to do but we are on slightly different software than you are.


JohnBClark :us: (BOB member since 2007-03-27)