12-01-04, 07:35 #1Registered User
- Join Date
- Dec 2004
Unanswered: connecting to SQL DB through a firewall
I'm a bit new to all this, so please bear with me!
I've got a webserver in our DMZ and I'm trying to create an ODBC connection from that server to a db server within our firewall. When I try and connect, the following message appears:
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()),
SQL State: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied
I'm at a bit of a loss as to what's going on, as we have an application on the webserver that connects to another SQL DB server within our firewall with no problem!
OS - win2000 standard server sp4
OS - WinNT 4.0
SQL - 7.0
If anyone can help, it would be much appreciated!!
12-01-04, 07:50 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
I'd recommend (so does MS) to have a VPN tunnel for intrasver communications, especially if they are on opposite sides of the firewall."The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."