Accessing sql server behind proxy

[John]

Hi

My app is running on a windows 2000 server with isa 2000 installed. How can
it access an external sql server (using its ip) from within the isa 2000
firewall/proxy via code?

Thanks

Regards

 

[Cor Ligthert [MVP]]

You would have to configure your ISA server, but in my idea is that not
possible with AdoNet or Visual Basic.

Cor

 

[Shijaz Abdulla [MVP]]

You will have to first create publishing rules on your ISA Server to publish
SQL Server. Basically this is to allow your application on the internet talk
to your internal SQL Server via the firewall in a secure manner.

For more information on creating server publishing rules, see ISA help.

Here is some additional info:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/proxy.mspx
http://support.microsoft.com/kb/299673

--
Shijaz Abdulla
MVP, MCSE:Security, CCNA

Articles: www.shijaz.com/isaserver
Forums: www.tech-links.org

"If the only tool you have is a hammer, every problem begins to look like a
nail."

 

[John]

Hi Shijaz

My problem is actually opposite. I am inside the ISA 2000 and trying to
access a remote SQL server somewhere using the sql server's ip address. It
may be possible to reverse the information provided in the article but I am
about that ISA savvy to do it on my own.

Thanks

Regards

 

[William \(Bill\) Vaughn]

First, have you exposed your SQL Server 2000 to the network? That is, do you
have the protocols and interfaces enabled. Which port is it using? It might
(just might) be using 1433. The port must be exposed through the firewall.
Generally, one does not connect to an external (LAN) SS via IP/port--that's
what the DNS is for. If you expose it to the WWW you're opening it up for
attack--and it will be attacked--especially if it exposes the default ports.

hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...

 

[John]

Hi Bill

The sql server is remote with our hosting company. They have provided its ip
address. I (from inside isa) need to configure isa to allow access to that
sql server.

Thanks

Regards

 

[William \(Bill\) Vaughn]

Generally, it's safer (by far) to expose SQL Server over a VPN, and XML Web
Service or use a server-side application to access the data.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------