• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1221
  • Last Modified:

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 192.168.0.10 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.
0
rot299
Asked:
rot299
2 Solutions
 
Partha MandayamTechnical DirectorCommented:
What happens when you try to register in Enterprise manager using IP 192.168.0.10
0
 
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.
0
 
LlamaJoeCommented:
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)
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

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.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
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

0
 
arbertCommented:
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.

Brett
0
 
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?
0
 
arbertCommented:
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....
0
 
rot299Author Commented:
Ok, well thanks for all the help.
0
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now