Connecting to SQL Server 2000 from DMZ

[HouDog]

Hi all,

I am having problems connecting to sql server 2000 from our web server sitting in a DMZ and would appreciate any help. I have SQL Server 2000 running on Server 2003. I have a web server (IIS 6.0) runnon on Server 2003. I also have a ISA server. I am simply trying to create a datasource on the webserver to connect to the sql server but it keeps erroring out with a sql server not found message. I'm pretty sure we have all "pinholes" setup to allow for this but it won't work.

Thanks,
JH.

 

[JayKusch]

So you have made sure that port 1433, or in some cases port 1434, are accessible?

Thanks

J. Kusch

 

[mrdenny]

See if you can telnet from the web server to port 1433 on the SQL Server

telnet SQLServer 1433

Run that from a command prompt. If that doesn't work then the ISA isn't setup correctly, or the SQL Server isn't listening.

Denny

--Anything is possible. All it takes is a little research. (Me)