[Last Call] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2008-11-05
Medium Priority
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

jmoss111 earned 2000 total points
ID: 22887845
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

ID: 22893634
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 xxx.xxx.xxx.xxx . I have a Cisco router that handles the NAT statement - ip nat inside source static xxx.xxx.xxx.xxx 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    xxx.xxx.xxx.xxx:1433        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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Configuring network clients can be a chore, especially if there are a large number of them or a lot of itinerant users.  DHCP dynamically manages this process, much to the relief of users and administrators alike!
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 (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), 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…
Suggested Courses

830 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