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

Jan 21 '07 #1

Subscribe Reply

2163

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

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

Jan 21 '07 #2

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/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.in fovis.co.ukwrot e in message
news:%2******** ********@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

Jan 21 '07 #3

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

"Shijaz Abdulla [MVP]" <sh****@shijaz. comwrote in message
news:99******** *************** ***********@mic rosoft.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.in fovis.co.ukwrot e in message
news:%2******** ********@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

Jan 21 '07 #4

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...
-----------------------------------------------------------------------------------------------------------------------
Microsoft MVP, Author, Mentor
Microsoft MVP
"John" <Jo**@nospam.in fovis.co.ukwrot e in message
news:%2******** ********@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

Jan 21 '07 #5

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" <billva@NoSpamA tAll_betav.comw rote in message
news:OH******** ******@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" <Jo**@nospam.in fovis.co.ukwrot e in message
news:%2******** ********@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

Jan 21 '07 #6

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

"John" <Jo**@nospam.in fovis.co.ukwrot e in message
news:O3******** ******@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:OH******** ******@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" <Jo**@nospam.in fovis.co.ukwrot e in message
news:%2******* *********@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

Jan 22 '07 #7

Similar topics

4098

Accessing Java WebServices with C#

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". Everything is fine... But I'm behind a proxy and I got this message, after type my username and password (in the "Discovery Credential for Proxy Server" popup: "The underlying connection was closed: Unable to connect to the remote server."

C# / C Sharp

2643

Accessing Web Service with HTTP status 407: Proxy Access Denied

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 web methods can be invoked successfully if "WebApplication1" is located in machines with the same subnet (128.1.7.x). However, it fails if "WebApplication1" is hosted on

ASP.NET

3509

Using a webservice through a proxy server.

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 the webservice but it comsumes very much time (60-90 seconds). When the client is not behind the proxy server then everything runs smooth. So my question how can I "workaround" this extra timedelay when the app is behind av proxy? Is there some...

Visual Basic .NET

3050

Accessing Webservices from behind proxy server

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 in VS2003 using VB.net on framework 1.1, Database is sql server 2000 Application works perfectectly ok and no problems at all even if there is a firewall in between. Question is would my application have any problems if it is calling the

.NET Framework

1207

accessing webservices from behind a proxy server.

by: sameer | last post by:

.NET Framework

2884

Webservices called from behind proxy server fails

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 of them is ISA ... if i a not wrong), if yes how? Sameer

.NET Framework

1088

Trouble accessing web service from behind ISA

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 properties I need to set in my code, other than the proxy-server address, to get this application to connect to the remote server; or if there are properties that need to be set on the ISA server itself to allow my application through? Below is a sample...

.NET Framework

6496

accessing URLs outside firewall with WebClient? error: The underlying connection was closed

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 <authentication mode="Windows" /> and set up IIS to not allow anonymous access. My browser is set up to auto detect the proxy server, so IE/Firefox can access outside pages, so I added code to auto-detect the proxy server.

ASP.NET

4469

Accessing a web service - proxy problem

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 this exception: System.Net.WebException: The request failed with HTTP status 407: Proxy Authentication Required. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream...

.NET Framework

9666

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10200

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10142

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9986

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7529

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6769

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5551

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3703

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2909

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General