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.