Super User is a question and answer site for computer enthusiasts and power users. 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

In MSDN to make SQL Server accessible from Internet

They say to forward port from sql server remote port to usual sql server port 1443.

I have at a hosting company 2 dedicated windows server 2008 which have Intel 82574L Gigabit Network Adapters. How can I do this on the computer that has SQL Server installed ?

share|improve this question

You could use:

C:\>netsh interface portproxy add v4tov4 listenport=12345 listenaddress=192.168.A.B connectport=54321 connectaddress=192.168.X.Y

Where 12345 is your external port that you want to connect to, 54321 will be the destination port (your 1443). Address 192.168.A.B is the address where you access 12345 port and 192.168.X.Y is the address where you have port 54321 located. Both addresses can be the same in case you want to redirect the port on the same machine.

share|improve this answer
I forgot to mention that with command "netsh interface portproxy show all" you will get full list of forwarder ports on the machine – Peter Jun 5 '11 at 20:41

First you need to allow incoming traffic to the port 1443 in the windows Firewall of the server that have installed SQL Server on it, then you need to access the hosting company control panel and view if there's a panel to configure port Forwarding, and then forward the port 1443 to the ip address of the server that have installed SQL Server ...

share|improve this answer
The external port is 2301 that's the one I put already in Firewall. What I need is to forward this one to 1443. I don't have any control panel at hosting service, it's a dedicated server with Remote Desktop Access and Full admin rights. – user75875 Jun 2 '11 at 8:17
And my question is not about WHAT to forward but HOW to forward (command line I would type) – user75875 Jun 2 '11 at 8:18

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .