Solved

Connect to MS SQL on different subnet

Posted on 2004-10-11
8
1,204 Views
Last Modified: 2008-02-26
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
Comment
Question by:rot299
8 Comments
 
LVL 6

Expert Comment

by:mcp111
ID: 12283346
What happens when you try to register in Enterprise manager using IP 192.168.0.10
0
 
LVL 1

Author Comment

by:rot299
ID: 12283378
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
 
LVL 5

Assisted Solution

by:LlamaJoe
LlamaJoe earned 250 total points
ID: 12283466
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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 1

Author Comment

by:rot299
ID: 12283709
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
 
LVL 34

Accepted Solution

by:
arbert earned 250 total points
ID: 12283837
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
 
LVL 1

Author Comment

by:rot299
ID: 12283998
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
 
LVL 34

Expert Comment

by:arbert
ID: 12284220
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
 
LVL 1

Author Comment

by:rot299
ID: 12284233
Ok, well thanks for all the help.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL: Do I need CLUSTERED here? 13 45
What's wrong with this T-SQL Foreign Key? 7 46
MS SQL + Insert Into Table - If Doesnt Exist 9 35
transaction in asp.net, sql server 6 33
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question