Unable to connect to SQLServer-2005 using JDBC Adapter in wM 9.5 SP1

We are unable to connect to MS SQL 2005 database from wM9.5 (JDBCAdapter package is 6.5 version) and throws below error message:

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Folder_Name:Connection_Name.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection Folder_Name:Connection_Name: after 1 attempt(s).
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.sqlserver.jdbc.SQLServerDataSource”.
The TCP/IP connection to the host SERVERNAME, port 1433 has failed. Error: “Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.”.

Correct DataSource className “com.microsoft.sqlserver.jdbc.SQLServerDataSource” has been provided as mentioned in the JDBC Adpater Guide.
We have latest “sqljdbc4.jar” JDBC Driver which supports SQL 2012, 2010 , 2008 & 2005 placed in the IntegrationServer/package/WmJDBCAdapter/code/jars directory but we can’t see it in the class-path list under IS home>About page.
Since, we are able to connect to SQLServer2012 using JDBC which is local connection (MSSQL 2012 hosted on same machine as IS), we do NOT consider this as any missing jar file issue.

Besides, we have also tried placing old MS SQL2005 JDBC drivers from MS site but everytime it throws the same error.

We have also searched the SoftwareAG TechCommunity site for the resolution and have tried all probable solutions provided in the forum.

When Checked with our Network Team and they have confirmed that there is no firewall between the IS & MS SQL2005 db Server. Browsing through various web sites leads us to think that it can be a minor TCP/IP port issue at MS-SQL side and Default Listner Port might not have been Enabled.(last thread in reference url - http://scn.sap.com/thread/3472988 ) .

Please provide your valuable thoughts. Thanks

Forgot to add one important point:
Successfully ABLE to connect to MSSQL 2005 Server DB ( Remote Server ) using MSSQL Server Management Studio which is installed on same Machine as IS.

try to use sqljdbc.jar instead.

check this about the differences:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8c1721c1-781f-4ad0-b656-a2494f3c3978/microsoft-sql-server-jdbc-driver-differences-between-sqljdbcjar-and-sqljdbc4jar?forum=sqldataaccess

Hi Tong,

Thanks for the reply. “sqljdbc4.jar” DO support SQL Server 2005.
Here’s the link from the MicroSoft site & Note. http://msdn.microsoft.com/en-US/sqlserver/aa937724.aspx

Note : The Microsoft SQL Server JDBC Driver 4.0 is a Java Database Connectivity (JDBC) 4.0 compliant driver that provides robust data access to SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and SQL Azure.

We have even tried “sqljdbc.jar” for SQL2005 and it thrown below error:

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Test_Prateesh:NDS_JDBC_Connection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

Our wM 9.5 IS has JRE Ver 1.7.0_25 (51.0) .
Few more points to be Considered here (taken from webMethods System Requirement & installation Guide & MS Site )

sqljdbc.* >>>

sqljdbc.jar class library provides support for JDBC 3.0.
sqljdbc.jar class library requires a Java Runtime Environment (JRE) of version 5.0. Using sqljdbc.jar on JRE 6.0 or JRE 7.0 will throw an exception when connecting to a database.

Note
The JDBC Driver does not support JRE 1.4. You must upgrade JRE 1.4 to JRE 5.0, JRE 6.0, or JRE 7.0 when using the JDBC Driver. In some cases, you might need to recompile your application because it might not be compatible with JDK 5.0 API or JDK 6.0 API. For more information, see the documentation on Sun Microsystems Web site.Microsoft JDBC Driver 4.0 for SQL Server does not support JDK 7.

sqljdbc4 >>>>>

sqljdbc4.jar class library provides support for JDBC 4.0 API. It includes all of the features of the sqljdbc.jar as well as the new JDBC 4.0 API methods.
sqljdbc4.jar class library requires a Java Runtime Environment (JRE) of version 6.0 or 7.0. Using sqljdbc4.jar on JRE 5.0 will throw an exception.

Note
Use sqljdbc4.jar when your application must run on JRE 6.0 or 7.0, even if your application does not use JDBC 4.0 API features.

Does it mean wM 9.5 is NOT compatible with SQL Server2005 ? if No, is there any work-around for the same without affecting other wM 9.5 features.

Any more thoughts will be highly appreciated.

Regards,
pbprateesh

webMethods 9.5.1 supports only MS SQL Server 2008, 2008 R2 & 2012…

Check http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/wmsuites/wmsuite9-5_sp1/SysReqs_Installation_and_Upgrade/9-5_System_Requirements.pdf - page 4 for more details…

-senthil

Hi Senthil,

Thanks a lot for the quick response. :slight_smile:
We are trying to connect with SoftwareAG to get an official confirmation on the same.

Best Regards,
pbprateesh