Connection to SQLserver

We have a server running SQL2000 which I am trying to get access to via the
internet. I have used the port forwarding setup on our router/firewall to
transfer all traffic on port 1433 to the server 192.168.0.99. I cannot get a
connection as it states the server was not found or it was denied access.
I have a similar method of access to a couple of Personal Addition setups
off site and I can get a connection.
What is slightly unusual is that I have two connections to the internet one
leased line where I can't get access to the firewall and a broadband where I
do. Both are running NAT. Is this an area to check
Thanks for a pointers you can give me
Ian
"Ian Rudge" <Ian.Rudge@.shaw.co.uk> wrote in message
news:Opx2sOvmEHA.556@.tk2msftngp13.phx.gbl...
> We have a server running SQL2000 which I am trying to get access to via
the
> internet. I have used the port forwarding setup on our router/firewall to
> transfer all traffic on port 1433 to the server 192.168.0.99. I cannot get
a
> connection as it states the server was not found or it was denied access.
> I have a similar method of access to a couple of Personal Addition setups
> off site and I can get a connection.
> What is slightly unusual is that I have two connections to the internet
one
> leased line where I can't get access to the firewall and a broadband where
I
> do. Both are running NAT. Is this an area to check
Maybe. There are a lot of variables in getting this to work properly. Check
this article along with links for troubleshooting this setup
http://support.microsoft.com/default...b;en-us;287932
BTW, I hope that was only a fictitious external IP address for your
server...
Steve
|||Thank you for pointers and I will start my search from that.
The IP address is fictional but as it is internal in the 192.168... range I
thought you couldn't get to it or should I panic?
Thx
Ian
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:OGpa1X0mEHA.3876@.TK2MSFTNGP15.phx.gbl...
> "Ian Rudge" <Ian.Rudge@.shaw.co.uk> wrote in message
> news:Opx2sOvmEHA.556@.tk2msftngp13.phx.gbl...
> the
> a
> one
> I
> Maybe. There are a lot of variables in getting this to work properly.
> Check
> this article along with links for troubleshooting this setup
> http://support.microsoft.com/default...b;en-us;287932
> BTW, I hope that was only a fictitious external IP address for your
> server...
> Steve
>
|||You're right, I should have recognized that range ;) No need to panic, it
goes without saying that you need a good firewall and isolation from the
"outside".
Steve
"Ian Rudge" <Ian.Rudge@.shaw.co.uk> wrote in message
news:%23rcxs97mEHA.3628@.TK2MSFTNGP09.phx.gbl...
> Thank you for pointers and I will start my search from that.
> The IP address is fictional but as it is internal in the 192.168... range
I[vbcol=seagreen]
> thought you couldn't get to it or should I panic?
> Thx
> Ian
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:OGpa1X0mEHA.3876@.TK2MSFTNGP15.phx.gbl...
to[vbcol=seagreen]
access.[vbcol=seagreen]
setups
>
|||I think I have found my answer. If I want to connect from outside, the
gateway for the SQLServer machine must point to the Broadband router not the
leased line one
Thx
for the help
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:OEGQIECnEHA.1236@.TK2MSFTNGP09.phx.gbl...
> You're right, I should have recognized that range ;) No need to panic, it
> goes without saying that you need a good firewall and isolation from the
> "outside".
> Steve
> "Ian Rudge" <Ian.Rudge@.shaw.co.uk> wrote in message
> news:%23rcxs97mEHA.3628@.TK2MSFTNGP09.phx.gbl...
> I
> to
> access.
> setups
>