Connecting to SQL 2005 Instance using an external IP address without specifying a port number

Posted on 2008-11-05
Last Modified: 2013-11-29
I have a Win2k3 Std 64bit server running SQL 2005 Std. It's internal IP address is mapped to an external IP address using NAT. External users need to connect to the SQL instance without specifiying a port number  (i.e. 'instance','port number') using the external IP address. At the moment users need to specify both the instance and port number to be able to connect to the database using the external IP. Is there any way of configuring SQL or the network to prevent having to use a port number to connect to the instance using the external IP address? Thanks in advance!
Question by:ccarrack
    LVL 18

    Accepted Solution

    I may be wrong but I thought that if the SQL Browser was running that it would handle it. You might have the browser turned off though...

    Author Comment

    Thanks but the SQL Browser service is started.

    Let me provide some more information. The server has a signle NIC assined with an inetrnal IP address . I have a Cisco router that handles the NAT statement - ip nat inside source static yyy.yyy.yyy.yyy . This allows the server to communicate with the outside world and vice versa. Ports 1433 and 1434 are both open on the firewall.

    Users connect to the SQL database from the outside using the external address yyy.yyy.yyy.yyy . However when defining the instance value they need to enter 'instance_name,portnumber' and not just 'instance_name' which is what is required. If I do a netstat query I get the following information.
    When no one is connected (or no connection can be made becuase user is using only the 'instance_name'):
    TCP               LISTENING

    When someone connects using  
    TCP               LISTENING
    TCP        zzz.zzz.zzz.zzz:1365      ESTABLISHED
    where zzz.zzz.zzz.zzz

    In SQL configuration manager I can only configure TCP/IP port numbers for the internal IP address (since there is only 1 NIC).

    I think this is problem lies in the router configuration. How can I tell a Cisco router to route anything looking for yyy.yyy.yyy.yyy on a specific port? In this case port 1433.

    Thanks again.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Understanding FTPS File transfer is a common requirement in most Enterprises. While there are numerous ways to get a file from Point A to Point B over a network, perhaps the most common method still in use is FTP – File Transfer Protocol. FTP is …
    The article explains the protocols and technology which is involved when two computers on different TCP/IP networks communicate with each other. In the diagram, a router is used to segregate two networks. The networks are and 192…
    Viewers will learn how to properly install and use Secure Shell (SSH) to work on projects or homework remotely. Download Secure Shell: Follow basic installation instructions: Open Secure Shell and use "Quick Connect" to enter credentials includi…
    After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now