Accessing sql server behind proxy

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
Sat Jan 20 23:54:35 CST 2007

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

Cor

"John" <John@nospam.infovis.co.uk> schreef in bericht
news:%23jncfMRPHHA.3552@TK2MSFTNGP03.phx.gbl...
> 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
>
>

Shijaz
Sun Jan 21 04:14:47 CST 2007

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" <John@nospam.infovis.co.uk> wrote in message
news:%23jncfMRPHHA.3552@TK2MSFTNGP03.phx.gbl...
> 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
>
>

John
Sun Jan 21 10:11:12 CST 2007

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

"Shijaz Abdulla [MVP]" <shijaz@shijaz.com> wrote in message
news:99948C8B-4FBE-40CF-9227-D9F44AEC0B1B@microsoft.com...
> 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" <John@nospam.infovis.co.uk> wrote in message
> news:%23jncfMRPHHA.3552@TK2MSFTNGP03.phx.gbl...
>> 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
>>
>>
>

William
Sun Jan 21 14:05:53 CST 2007

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...
-----------------------------------------------------------------------------------------------------------------------


Microsoft MVP, Author, Mentor
Microsoft MVP
"John" <John@nospam.infovis.co.uk> wrote in message
news:%23jncfMRPHHA.3552@TK2MSFTNGP03.phx.gbl...
> 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
>
>

John
Sun Jan 21 14:25:17 CST 2007

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" <billva@NoSpamAtAll_betav.com> wrote in message
news:OHviYeZPHHA.5012@TK2MSFTNGP02.phx.gbl...
> 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...
> -----------------------------------------------------------------------------------------------------------------------
>
>
> Microsoft MVP, Author, Mentor
> Microsoft MVP
> "John" <John@nospam.infovis.co.uk> wrote in message
> news:%23jncfMRPHHA.3552@TK2MSFTNGP03.phx.gbl...
>> 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
>>
>>
>
>

William
Sun Jan 21 21:54:49 CST 2007

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)
-----------------------------------------------------------------------------------------------------------------------

"John" <John@nospam.infovis.co.uk> wrote in message
news:O3APGpZPHHA.4124@TK2MSFTNGP06.phx.gbl...
> 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" <billva@NoSpamAtAll_betav.com> wrote in message
> news:OHviYeZPHHA.5012@TK2MSFTNGP02.phx.gbl...
>> 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...
>> -----------------------------------------------------------------------------------------------------------------------
>>
>>
>> Microsoft MVP, Author, Mentor
>> Microsoft MVP
>> "John" <John@nospam.infovis.co.uk> wrote in message
>> news:%23jncfMRPHHA.3552@TK2MSFTNGP03.phx.gbl...
>>> 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
>>>
>>>
>>
>>
>
>