By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,885 Members | 1,072 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,885 IT Pros & Developers. It's quick & easy.

Accessing sql server behind proxy

P: n/a
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
Jan 21 '07 #1
Share this Question
Share on Google+
6 Replies


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

Cor

"John" <Jo**@nospam.infovis.co.ukschreef in bericht
news:%2****************@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


Jan 21 '07 #2

P: n/a
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" <Jo**@nospam.infovis.co.ukwrote in message
news:%2****************@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

Jan 21 '07 #3

P: n/a
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]" <sh****@shijaz.comwrote in message
news:99**********************************@microsof t.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" <Jo**@nospam.infovis.co.ukwrote in message
news:%2****************@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


Jan 21 '07 #4

P: n/a
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" <Jo**@nospam.infovis.co.ukwrote in message
news:%2****************@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


Jan 21 '07 #5

P: n/a
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.comwrote in message
news:OH**************@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" <Jo**@nospam.infovis.co.ukwrote in message
news:%2****************@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



Jan 21 '07 #6

P: n/a
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" <Jo**@nospam.infovis.co.ukwrote in message
news:O3**************@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.comwrote in message
news:OH**************@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" <Jo**@nospam.infovis.co.ukwrote in message
news:%2****************@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




Jan 22 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.