December 8, 2008 at 10:56 pm
Dear All,
There are 3 SQL servers (in three different machines ) installed at one of our client's office.
All the 3 servers are in LAN.
But when I connect with their public IP from my office (remote location), I get to see only one SQL Server.
How can I access the remaining two SQL Servers..?
What setting needs to be done for that..?
Please guide..It's urgent
Thanks in advance..
Santhu.
December 9, 2008 at 6:39 am
Couple of questions:
Does each SQL Instance sit on a different machine and you have different IP addresses?
Is there a single public IP and that redirects traffic to the machines behind it?
Do all SQL instances sit on the same server?
Is there a firewall in place?
December 9, 2008 at 6:52 am
1. Each SQL Instance sit on a different machine and you
have different IP addresses.
2. There a single public IP and that redirects traffic to the
machines behind it.
3. All SQL instances DONOT sit on the same server.It's
different (point no. 1)
4. There is a firewall in place.
Thanks.
December 9, 2008 at 6:59 am
How does the single public IP route traffic to the 3 servers behind the firewall?
December 9, 2008 at 7:47 am
SQL Server connections are through a port/IP combination, essentially a socket. If you have 3 servers all on default settings, and 1 public IP, you cannot connect through 1433 to them all. The router will not know how to move traffic.
You can a) change the network settings of 2 SQL Server instances to respond to different ports
or b) redirect traffic on the public IP at different ports down to a specific IP and 1433 for each server.
In either case, you need to setup networking to access the other 2 SQL Servers on a high port, pick something over 50000.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply