Posts Tagged Configuration Test Failed

Tibco BusinessWorks – BW-JDBC-100034 "Configuration Test Failed. Exception [] occurred. Connection reset

Ashish Gupta

BW-JDBC-100034 “Configuration Test Failed. Exception [] occurred. Connection reset

<ns1:JDBCSQLException xmlns:ns1 = ““>
<msg>”JDBC error reported: (SQLState = 08S01) – Connection reset ClientConnectionId:396457ef-182e-4ddb-8b50-57541ce45b3b”</msg>
<detailStr> Connection reset ClientConnectionId:396457ef-182e-4ddb-8b50-57541ce45b3b</detailStr>

I saw this issue in a Tibco BusinessWorks application using a SQL JDBC Driver 4.0 to connect to a SQL server 2008 R2 server. However, I believe that this could happen with any application written in Java/.NET using JDBC driver 4.0 connecting to SQL server 2008 R2 server.

:- Check If at least Microsoft® SQL Server® 2008 R2 Service Pack 2 is installed on the SQL server. If not, install it. If SP2 or Higher (e.g. SP3) is already installed and you still see the same issue – problem is something else.

Connect to the server from the SQL Management Studio and execute the below query :-

You should see the SP2 as…

View original post 176 more words

, , , ,

Leave a comment

Random Thoughts

The World as I see it

Simple Programmer

Making The Complex Simple

Ionic Solutions

Random thoughts on software construction, design patterns and optimization.

Long (Way) Off

A tragic's view from the cricket hinterlands