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

Re: Accessing sql server behind proxy

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.in fovis.co.ukschr eef in bericht
news:%23jncfMRP HHA.3552@TK2MSF TNGP03.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 Abdulla [MVP]]

Re: Accessing sql server behind proxy

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/pro...ain/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.in fovis.co.ukwrot e in message
news:%23jncfMRP HHA.3552@TK2MSF TNGP03.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]

Re: Accessing sql server behind proxy

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. comwrote in message
news:99948C8B-4FBE-40CF-9227-D9F44AEC0B1B@mi crosoft.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/pro...ain/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.in fovis.co.ukwrot e in message
news:%23jncfMRP HHA.3552@TK2MSF TNGP03.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 \(Bill\) Vaughn]

Re: Accessing sql server behind proxy

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

https://www.betav.com/blog/billva

https://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.in fovis.co.ukwrot e in message
news:%23jncfMRP HHA.3552@TK2MSF TNGP03.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]

Re: Accessing sql server behind proxy

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@NoSpamA tAll_betav.comw rote in message
news:OHviYeZPHH A.5012@TK2MSFTN GP02.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

https://www.betav.com/blog/billva

https://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.in fovis.co.ukwrot e in message
news:%23jncfMRP HHA.3552@TK2MSF TNGP03.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 \(Bill\) Vaughn]

Re: Accessing sql server behind proxy

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

https://www.betav.com/blog/billva

https://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.in fovis.co.ukwrot e in message
news:O3APGpZPHH A.4124@TK2MSFTN GP06.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@NoSpamA tAll_betav.comw rote in message
news:OHviYeZPHH A.5012@TK2MSFTN GP02.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.in fovis.co.ukwrot e in message
>news:%23jncfMR PHHA.3552@TK2MS FTNGP03.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
>>>
>>>

>>
>>

>
>