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

    Join Date
    Nov 2002
    Posts
    410
    Rep Power
    19

    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
    SQLMANGR.EXE Accept 255.255.255.255

    Could you please give me a hand?

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

    Join Date
    Jul 2001
    Location
    Lynn, MA
    Posts
    4,635
    Rep Power
    82
    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
    Posts
    7,322
    Rep Power
    33
    stanley1610

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

    We now have 3 threads on exactly the same topic:

    http://forums.devshed.com/t51459/s.html
    http://forums.devshed.com/t51457/s.html
    http://forums.devshed.com/t51458/s.html

    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