I am not able to create Jdbc adapter connection and getting below error when I try to enable the connection.
“[ADA.1.204] Cannot connect to the database with DataSource class “com.wm.dd.jdbcx.sqlserver.SQLServerDataSource”.
[SoftwareAG][SQLServer JDBC Driver]Error establishing socket to host and port: localHost:1433. Reason: Connection refused: connect”.
But when I changed the database server, I am able to do it.
I am trying to create the connection using the database which is hosted at my machine and Integration server is hosted at another machine.
Can any one please try to resolve this as soon as possible.
Thanks in Advance.