Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have SQL Server 2005 operating on a remotely hosted server and wish to access it from my own machine using management studio

The firewall on the remote server is allready setup to allow all traffic from my external IP - and that works great.

However I have a load balancing router that has a second line attached to it - unfortunatly the second line has a dynamic external IP.

I need to therefore set up a rule in the router to always send data from Management studio on the first line - but I need to know the port numbers.

Can you advise?

share|improve this question
up vote 3 down vote accepted

1433 and 1434. Due to how the slammer worm operated, you'll find that a lot of ISPs out there filter these ports.

share|improve this answer
Worked perfectly thanks – Martin Mar 16 '10 at 8:50

You can also set SQL Server to listen on a specific port of your choosing. Here's a good article on how to set it up.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.