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 - MII 14.0 database connection error to MSSQL Server 2012 | SAP Community ). When Checked with our Network Team and they have confirmed that there is no firewall between the IS & MS SQL2005 db Server. We have also searched the SoftwareAG TechCommunity site for the resolution and have tried all probable solutions provided in the forum. 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.īesides, we have also tried placing old MS SQL2005 JDBC drivers from MS site but everytime it throws the same error. 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. 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.”.Ĭorrect DataSource className “.SQLServerDataSource” has been provided as mentioned in the JDBC Adpater Guide. ![]() The TCP/IP connection to the host SERVERNAME, port 1433 has failed. Cannot connect to the database with DataSource class “.SQLServerDataSource”. Adapter Runtime (Connection): Unable to configure connection manager. ![]() ![]() Adapter Runtime (Connection): Unable to start connection Folder_Name:Connection_Name: after 1 attempt(s). Adapter Runtime (Connection): Unable to enable connection resource Folder_Name:Connection_Name. We are unable to connect to MS SQL 2005 database from wM9.5 (JDBCAdapter package is 6.5 version) and throws below error message:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |