Sql Browser running but udp 1434 is not listening

Question

HI masters,
I need to open 1434 port on local pc. The SSB is running and cmd command "netstat -an | findstr ":1434" shows me these results.

how can I configure 1434 port or SSB to force SSB listen that port?

I can't connect to named instance.
Thanks in advanced

Answer 1

Hi @mr ajaxian ,

Welcome to Microsoft Q&A!
You can try the two methods mentioned in this link which are very detailed :
https://github.com/MicrosoftDocs/SupportArticles-docs/blob/main/support/sql/connect/resolving-connectivity-errors.md#cause-5named-instance-udp-port-1434-used-by-sql-browser-is-blocked-on-the-network

Best regards,
Seeya

---

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.

Answer 2

If you want to configure a specific port for SQL Server then you have a nice tutorial at Microsoft's documentation:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver15

Answer 3

NetStat shows the list of existing connections. Clients connect only very brief to SSB to get the instance port.
That's why you get only 0.0.0.0:1434 in your list.

I can't connect to named instance.

So you get an error message on connect; which one?
By default named instances use a different IP port then 1433; may be the used port is blocked by a firewall.

Answer 4

Thanks all. Finaly found the problem. I was using telnet to check the 1434 port. The telnet can't connect UDP ports, just TCP ports. In addition, I've checked the Router config, and I've added a udp rule.

To find a problem I used PortQryUi (https://www.microsoft.com/en-us/download/details.aspx?id=24009) in local network, to check the UDP port working or not.