Share via

Application unable to connect to Listener intermittently on port 1433

Amisha Bhadauria 0 Reputation points
2024-07-21T04:05:37.09+00:00

We have a named instance that's running on a dynamic port, with a Listener specified on port 1433. All application strings only specify the listener IP and port. A scheduled job connects to the listener once a day, but it sometimes fails with the error message:

"Could not get JDBC Connection; The TCP/IP connection to the host 'LISTENER IP', port 1433 has failed. Error: 'connect timed out. 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.'"

We have not received any other error reports from any of the other applications. Could the issue be caused by dynamic ports? Should we assign 1433 to the instance as well? Would this cause any other issues like port conflicts, etc.?

Thank you in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,324 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LucyChenMSFT-4874 2,985 Reputation points
    2024-07-22T02:16:02.63+00:00

    Hi @Amisha Bhadauria ,

    Thank you for your reaching out and Welcome to Microsoft Q&A!

    Please check out this official document!

    In addition, you can check the following configurations:

    • Make sure the SQL Server instance is running.
    • Please go to SQL Server Configuration Manager -> expand SQL Server Network Configuration->Protocols for InstanceName, make sure TCP/IP is enabled.
    • Then go to TCP/IP properties-> IP Addresses tab, make sure SQL Server instance is listening on port 1433 under TCP port.
    • Please make sure you have configured the firewall on the computer running SQL Server to allow access.

    As Erland says, could you please tell us from where does this job run? SQL Server Agent? Or something else?

    Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

    0 comments