Hello All,
I’m getting an “Internet Server Error (500)” when trying to login to BFI Console with long Java backtrace that start with
"Java::ComMicrosoftSqlserverJdbc::SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “SQL Server did not return a response. The connection has been closed. ClientConnectionId:4fd45d69-edfc-44d7-9b60-113a4131404e”. from com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:1667) from com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(com/microsoft/sqlserver/jdbc/IOBuffer.java:1668) from com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:1323) from com.microsoft.sqlserver.jdbc.SQLServerConnection.login(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:991) from com.microsoft
Can anyone please help with the remediation steps.
Thanks for your prompt response.
I see that datanase is up and running (SQL services is also up), Port is listening and also from the bfi application server I am able to ping database server.
Don’t know what else to tell you, except perhaps to consult your database administrator or open a PMR. The error cited from the driver appears pretty clear. If it were an TLS / ciphers issue (which is pretty common as organizations step up to TLS 1.2 on some servers and not others), I’d expect a different message.
Even I suspect TLS issue.
Could you please explain more on TLS/ciphers issue and what need to be done . For example does tls setting need to be implemented on both the servers database as well as application ?
Trying to connect from SQL Management Studio on the BFI host, to the database on the database host, will give us some useful info. See if that works (in TLS mode on management studio)
Yes , I have opened PMR and waiting for their reply. Also wanted to highlight that we have BFI Prod and Dev with same configuration.
SQL.udl connection is working perfectly in prod Application but when it comes to dev it populate error when we click on 3 button dropdown