none
port 1434

    Question

  • C:\Users\Administrator>netstat -an | find "LISTENING"

      TCP    0.0.0.0:1433           0.0.0.0:0              LISTENING
      TCP    0.0.0.0:3389           0.0.0.0:0              LISTENING
      TCP    127.0.0.1:1434         0.0.0.0:0              LISTENING


    Port 1434 is listening to locally only. how to let it listen to 0.0.0.0 like port 1433?

      windows fw already opened.

    thanks.

    Wednesday, June 26, 2013 3:53 AM

Answers

All replies

  • Why / What should it be good for?

    If it's regarding SQL Server-Browser: The services uses UDP, not TCP so there is nothing to listen on.


    Olaf Helper

    Blog Xing

    Wednesday, June 26, 2013 4:20 AM
  • Why / What should it be good for?

    If it's regarding SQL Server-Browser: The services uses UDP, not TCP so there is nothing to listen on.


    Olaf Helper

    Blog Xing


    for internet access. like 3380,443, those listen to 0.0.0.0 , which mean internet.
    Wednesday, June 26, 2013 4:27 AM
  • Again, is it for SQL Server-Browser, which uses 1434? Then you only have to unblock inbound/outbound the port in your firewall, no need to change anything more.

    Olaf Helper

    Blog Xing

    Wednesday, June 26, 2013 5:11 AM
  • TCP port 1434 is used by the Dedicated Administrator Connection. Explained at Diagnostic Connection for Database Administrators http://technet.microsoft.com/en-us/library/ms189595.aspx It is intended for use locally (connections from the same computer). However that can be changed. See remote admin connections Server Configuration Option http://technet.microsoft.com/en-us/library/ms190468.aspx I think that's the info you want.

    Don't confuse this with UDP port 1434 which is for the SQL Server Browser service.


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Wednesday, June 26, 2013 3:38 PM