Open UDP port 1434 to browse named instances

Source: Internet
Author: User
Tags server error log
Question: A local ISP hosts our SQL Server, but I cannot see or connect to a named instance running on this computer. I know that the SQL Server 2000 naming instance does not use the TCP/IP port 1433, and is sure that the TCP/IP port used by the SQL Server instance is open. Do you have any suggestions?
Answer:: Many people know how to use the SQL Server network utility or SQL Server error log to determine the listening port of the SQL Server instance. However, many people seem to have forgotten or do not even know that UDP port 1434 must be opened to ensure that you can access and browse named instances correctly. I suggest you carefully study this requirement. Search "1434" in SQL Server online books and you will get three valuable search results. In my SQL Server practical skills column published on February 14, July 2001 on the SQL Server Magazine website, you can also find information about accessing the named instance (InstantDoc ID 21127 ). I would like to explain it briefly here. SQL Server creates a listening service on UDP port 1434, allowing the client to query a list of named instances and their network configurations from the Server. The listening service is always running on UDP port 1434 and cannot be changed.
-Brian Moran


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.