Welcome to ISAserver.org

SQL Server

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2000 General] >> Server Publishing >> SQL Server

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Server - 7.Oct.2005 5:07:00 AM

simonb1975uk

Posts: 1
Joined: 7.Oct.2005
From: Essex
Status: offline

Morning guys, I am unsure if this is an isa server setup problem or just something to do with the network configuration here but here goes. The setup is as follows: SQL Server on a router that goes out to a NAT'd and firewalled router that sits on our ADSL connection. We also have a Small Business server 2000 that connects to the router via a network card and 1 network card going to the LAN.

The server is used to be reachable internally as the server is on 192.168.111.x and our network runs using 192.168.0.x. However we recently had installed SDSL which connects to our network via another pc with ISA Server 2000 installed with 2 network cards 1 connected to our LAN on ip address 192.168.0.y and 1 connected to the SDSL router. However since I did this I can no longer connect to the sql server, I can ping it but cannot connect to it via Enterprise Manager. I'm a bit green when it comes ti ISA server but am learning quickly and any advice you guys can give would be greatly appreciated.

Simon

Post #: 1

Featured Links*

RE: SQL Server - 26.Oct.2005 12:10:00 AM

Malevil

Posts: 3
Joined: 10.Sep.2004
From: Northern California, USA
Status: offline

This sounds more like a routing problem than anything else.
A few critical pieces of information would really go a long way toward sorting this out.
First the subnet mask for both the SQL and the main LAN networks. And the default gateways for both.
If you are using 2 different address ranges (192.168.111.x and 192.168.0.x using a 255.255.255.0 subnet mask) without special routing instructions (in both ISA firewalls) connectivity becomes questionable with a high probability of routing loops. That would be my first thing to look at since you just added a new connection and the routing changed.

(in reply to simonb1975uk)

Post #: 2