Details
-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
1.4.1.Final
-
None
-
False
-
False
-
This was a configuration issue at my end
Description
My organization does not expose the default port 1433 for SQL server and we use named instances. I am trying to configure debezium engine to connected to a named instance but I am getting the following error even though we do not use 1433 port.
Error:
{"exception":"com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host xxxxxx, port 1433 has failed.
I have tried setting the port number to 0 also but the error persists. It am getting this error in 1.3.1.final as well as 1.4.1.final.
connector.class=io.debezium.connector.sqlserver.SqlServerConnector schemas.enable=true snapshot.mode=initial tasks.max=1 tombstones.on.delete=true poll.interval.ms=1000 heartbeat.interval.ms=0 snapshot.fetch.size=1000 max.batch.size=1000 max.queue.size=20000 offset.flush.interval.ms=5000 snapshot.lock.timeout.ms=10000 database.server.name=server1 database.hostname=ap20-dba-444.core.mycompany.org\silo_db database.dbname=ADDRESSBOOK database.port=50000 database.user=xxxxx database.password=xxxxx