473,326 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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
Jan 21 '07 #1
6 2087
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Daniel Santana | last post by:
Hi, about Java WebServices, accessed by C#, I have two questions: 1) what I have to do, in order to use java webservices? 2) I search and I guess I must type the wsdl path in "add web reference"....
0
by: George | last post by:
Hello, I'm running an ASPX application "WebApplication1" which consumes a web service (service1.asmx) hosted on a machine with IP (128.1.7.x) . The web service is located in the intranet. The...
2
by: Iceman | last post by:
I gave a VB.NET client which comsumes a webservices. The VB.Net client is behind a proxy server. The problem is when the VB.NET client i behind a proxy is goes very slow. It does get response from...
2
by: sameer | last post by:
hi all, Description of my .net application: Desktop application using webservices over the internet to communicate with the sql server2000 database which is sitting behind the webserver. Done...
0
by: sameer | last post by:
hi all, Description of my .net application: Desktop application using webservices over the internet to communicate with the sql server2000 database which is sitting behind the webserver. Done...
6
by: sameer | last post by:
..NET Framework 1.1 VS2003 Application is making webservice calls from behind a proxy server and then freezes and dies. Questoin is can i use webservice over proxy server( i guess another name...
0
by: DRotondo | last post by:
Hello all, I am developing an application that accesses a hosted web service, and I am developing it in a network that is behind ISA 2004. I was wondering if there are any other special...
1
by: Mad Scientist Jr | last post by:
For some reason I can't get a WebClient to access an outside URL from behind our firewall. The code works when it runs outside the firewall. I turned on windows authentication in the web.config...
4
by: Jon | last post by:
I wrote a VS 2005 C# express programme that accesses a web service. It works fine when there's a direct connection to the internet, but on two different PCs with internet access via a proxy, I get...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.