Welcome to ISAserver.org

SQL Server access from IIS

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2000 General] >> General >> SQL Server access from IIS

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Server access from IIS - 1.Jun.2004 5:46:00 PM

zsmb

Posts: 1
Joined: 1.Jun.2004
Status: offline

Hello,

I am new to ISA. We have Windows 2003 web server in the DMZ. ISA 2000 server is also in DMZ. I want to allow IIS to access data from a SQL in the internal network through the ISA. Can somebody be able to guide me? Thanks

Zolla

Post #: 1

Featured Links*

RE: SQL Server access from IIS - 7.Jun.2004 9:39:00 AM

khowlette

Posts: 33
Joined: 21.May2003
Status: offline

You need to create a server publishing rule for SQL. If this ia a MS-SQL server then ports 1433 will need to be specified. You may need UDP as well as TCP. If your using a ODBC conenction ensure the Client library is set to TCP/IP and not named pipes. You'll also have to use SQL Authenication, otherwise you'll have to open up RPC ports (aviod if possible).

Hope this helps

(in reply to zsmb)