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?