I am trying to create a JDBC data source to access a Microsoft SQL server. I am using sqjjdbc42.jar. When I attempt to test the connection, I receive this:
ERROR: The TCP/IP connection to the host alertsqlreporting.convergeone.com, port 1433 has failed. Error: "alertsqlreporting.convergeone.com. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". DSRA0010E: SQL State = 08S01, Error Code = 0
The EngagmentDesigner error is:
2019-01-15 14:36:31,505 [WebContainer : 1] EngagementDesigner ERROR - EngagementDesigner-3.5.0.1.52005 - Failed to get a DataSource from factory.
2019-01-15 14:36:31,505 [WebContainer : 1] EngagementDesigner ERROR - EngagementDesigner-3.5.0.1.52005 - Error getting Output Schema for Read DB Task
java.lang.IllegalStateException: Failed to initialize the DB connection: DB URL = jdbc:sqlserver://alertsqlreporting.nacr.com:1433
at com.avaya.workflow.base.db.dataaccess.DataAccessAgent.getAndInitDataAccess(DataAccessAgent.java:230)
I am not sure how to debug this. Does the problem come from connecting to the database, or is there a configuration problem. I am attaching a screen shot of the configuration.
|