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