Connect to MS SQL on different subnet

I have a remote hosting environment which includes two machines - a web server and an ms sql server. The sql machine uses an internal IP and the web server has a real IP as well as an internal IP (used to connect to sql server). Using this setup its not possible to ping or connect to the sql machine remotly. Is it possible to somehow setup a way to connect to the sql server via either Enterprise manager or Query Analyzer remotely?

If this is not possible is there any other way I can connect to it? I have full control of both machines so I can make any needed changes.
Who is Participating?
arbertConnect With a Mentor Commented:
You don't have to give the SQL box and external IP address (in fact, I wouldn't recommend it).  However, you do need to be able to set up forwarding or NAT on your router/firewall to allow port 1433 to be routed to your SQL Server on the internal network.

Partha MandayamTechnical DirectorCommented:
What happens when you try to register in Enterprise manager using IP
rot299Author Commented:
I didn't try because I know my remote machine (connected via the internet, not on the same network as the web and SQL server) will not find the internal IP. Sorry if I didn't make it clear that I want to connect to the sql box over the internet/remotley.
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

LlamaJoeConnect With a Mentor Commented:
If you are connecting remotely, then you have to give the SQL server an external IP...  

or, install sql on the web box and setup a linked server to your SQL box - then connect to the Web box and use the linked server as a means to connect...

or, specify a random port north of 2000 on the Web box to be forwarded to port 1433 on the sql box, then use the client network utility on your remote machine to create an alias to this new port on the Web box and connect through the alias.(this is much easier if you have a router between the web box and the internet)

or, download the SQL Server Web Data Administrator and see if that will work on your web box... (this is enterprise manager with a web front end)

or, run terminal services on your web box and then connect

or, create a vpn connection to your web box and then your remote machine is part of that network...

or, or, or... lots of options still can be dreamt of.  It really depends on the setup of your network and what pieces are available to be mucked with.
rot299Author Commented:
I currently do connect to the sql box by connecting via terminal to the web box then accessing the sql box but wanted a more direct method. I like the idea of forwarding a port on the web box to the sql box. I will try this out.

Thanks for the info

rot299Author Commented:
Ok thanks. Can I setup the port forwarding on the web server machine or does this have to be done on the router? The only issue is that the router isn't mine although I can probably ask the owner to set the forwarding if there is no other way.

Do you have any links to information on how to set this up?
You would want to set it up at the router.....

As far as how to do it, really depends on the router....Some call it port forwarding, some call it virtual servers, just depends....
rot299Author Commented:
Ok, well thanks for all the help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.