Ask Your Question

The connection using TCP/IP to SQLServer on port 1433 has not been successful for the targeted CDC DB with JDBC sink connector.

asked 2021-06-08 11:00:00 +0000

ladyg gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2021-10-01 16:00:00 +0000

david gravatar image

There could be multiple reasons for the unsuccessful connection. Here are a few steps you can take to troubleshoot the issue:

  1. Verify that SQLServer is running and listening on port 1433. You can use the command netstat -an to check if the port is open and listening.

  2. Check the firewall settings on the server hosting SQLServer. Make sure that port 1433 is open for incoming traffic.

  3. Verify that the JDBC driver for SQLServer is installed on the CDC server where the JDBC sink connector is running.

  4. Make sure that the JDBC URL provided in the sink connector configuration is correct and that it includes the correct hostname, port, database name, and credentials.

  5. Verify that the username and password provided in the configuration are correct and have sufficient privileges to access the targeted database.

  6. Check the logs of the JDBC sink connector to see if there are any error messages related to the connection.

  7. Try connecting to the database using a SQL client tool (such as SQL Server Management Studio) to verify that the connection works from the CDC server.

Once you have identified the root cause of the connection failure, you can take appropriate action to fix the issue.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools


Asked: 2021-06-08 11:00:00 +0000

Seen: 9 times

Last updated: Oct 01 '21