Board index MS SQL Server

Can IIS connect to firewalled database?

Can IIS connect to firewalled database?

Post by Steve Trende » Fri, 02 Apr 1999 04:00:00



I'm running IIS with SQL Server on a box outside of a firewall.  I want to
move the SQL Server behind the firewall.  Can IIS connect through the
firewall to SQL Server?  I know that I can setup SQL Servers on either side
of the fw and replicate the data, but there are a lot of drawback to going
this route.  Would using SiteServer help?

-Steve Trendel

 
 
 
Top

Can IIS connect to firewalled database?

Post by Pat Filote » Tue, 06 Apr 1999 04:00:00


IIS doesn't know or care WHERE the SQL box is.  To put SQL behind the FW do
the following:
1) turn off NAMED PIPES (these are bad anyway)
2) Put the SQL behind the FW
3) open up port 1433 (default port, user definable) for in/out bound traffic
(TCP)
4) specify that ONLY the IIS IP address has access to the port
5) specify that the outbound will ONLY go to the IIS box
6) to test, launch TELNET on the IIS box and attempt to attach to the SQL
server.

Pat Filoteo, MCSE


> I'm running IIS with SQL Server on a box outside of a firewall.  I want to
> move the SQL Server behind the firewall.  Can IIS connect through the
> firewall to SQL Server?  I know that I can setup SQL Servers on either
side
> of the fw and replicate the data, but there are a lot of drawback to going
> this route.  Would using SiteServer help?

> -Steve Trendel



 
 
 
Top

1. HELP: Connecting IIS to an Oracle Database

No matter what I do I always get the message "The Oracle client and
networking components were not found. These components are supplied by
Oracle Corporation ..."

I've tried disabling SQL*Net (Net8), I've looked for duplicate .dll
files, I've checked the PATH environment variables, and I've tried
using a DSN and going DSN-less with both the Microsoft provider and
the Oracle provider and no matter what I do I still get that error
message. Oracle connects just fine (using something like SQL*Plus) and
the IIS web server is up and running and processes ASP just fine.

Help please, I've been trying to get this working for two days.
Anybody got any ideas??

2. Performance degradation question w/transactions

3. Anyone know of some canned (cheap or free) DB performance testing software

4. How To : Efficient NextID

5. Canned PARADOX scripts?

6. Tell me about Oracle Events

7. bcp canned app

8. How to do this in a master-detail relationship?

9. MDX : Canned Report or OLAP

10. Switching from inhouse to canned package.

11. if you will promise Allahdad's swamp against cans, it will angrily depart the unit

12. canned code to get db on web quickly via perl or

13. Cans access2.0 engine access btrieve files?


All times are UTC
Board index