1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2002
    Rep Power

    Unhappy Database vs Firewall

    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

    Could you please give me a hand?

    - stanley
    Perl Kids Kiss Perl
  2. #2
  3. 11
    Devshed Demi-God (4500 - 4999 posts)

    Join Date
    Jul 2001
    Lynn, MA
    Rep Power
    This doesn't really have anything to do with perl, so I've moved it to the "Security" forum, for lack of a better place to put it.

    Looks like you messed up your access rights/network topology.
  4. #3
  5. Second highest poster :p
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jul 2001
    Rep Power

    Cross posting a thread on different forums is VERY annoying and wastes our time!

    We now have 3 threads on exactly the same topic:


    Before you even think of posting again read this thread http://forums.devshed.com/t24097/s.html on how to ask a question and what not to do.

    People do look in the different forums, I look in nearly all of them. Cross posting something is rude and very annoying since we end up reading things again and it wastes our time.
    - Andreas Koepke

    Koepke Photography

IMN logo majestic logo threadwatch logo seochat tools logo