February 6th, 2003, 08:15 AM
|
 |
Contributing User
|
|
Join Date: Nov 2002
Posts: 250
Time spent in forums: 16 h 15 m 52 sec
Reputation Power: 8
|
|
ODBC vs Firewall Policy
hi all,
I have got into a hot water after I have installed a firewall in my server. Before all, let me introduce my architecture.
There are three servers, Server 101, Server 102 and Server 106. Each of them contains one IIS Web server and one MS SQL Server 2000. I have installed a software firewall at Server 106.
When I access the web on Server 101, it will retrieve data from Server 106.
When I access the web on Server 106, it will retrieve data from Server 102.
After installing the firewall and setting its policy, I have found the following Error messages in my Perl CGI;
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
Oh, god. My codes are all dead. What should I do? I have set the following policies but no use;
SQLSERVR.EXE Accept Server 1, Server 2 and Server 6
SQLMANGR.EXE Accept Server 1, Server 2 and Server 6
SQLMANGR.EXE Accept 255.255.255.255
Could you please give me a hand?
- stanley
__________________
------------------------------------------
Perl Kids Kiss Perl
Stanley
------------------------------------------
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
