locked
Connection Issue RRS feed

  • Question

  • Hello all,

     

    Hoping I can get some help with a weird issue.

     

    I have two web servers connecting to a third server which has a sql 2005 database (named instance).

    One web server is in a DMZ and the other along with the database server is inside our LAN.

    Both of these web servers also connect to a sql 2000 database (default instance) on the same server as the SQL 2005 without any issues

    The web server inside of the LAN (Windows 2003) is able to connect to the 2005 database without issue.

    The one in the DMZ (Windows 2000) cannot and receives a named pipes error when trying to connect via sql native client

     

    When attempting to connect via connection string without odbc in a .net 1.1 application (using the same data which successfully works from the web server inside the LAN) ->

    SQL Server does not exist or access denied.

     

    We have opened ports 1434 and 1433 for access from the DMZ to the LAN after doing some research but this has not helped. We have remote connections for named pipes and tcp/ip turned on as well.

     

     

    Any assistance with this issue would be most appreciated.

     

    Thanks!

    Sunday, September 21, 2008 7:54 PM

All replies

  • Probably SQL Server itself is OK. Probably it is a network problem.
    Have you checked your firewalls/proxies? Is it possible to establish a connection from the DMZ machine to 1434 port on the server? Are you sure that your DB server is available outside your LAN, 1434 and 1433 ports forwarding configured on the firewall/proxy, etc?
    You can check (from the DMZ machine): telnet <hostname> 1434
    If it cannot connect, you will see.
    Wednesday, October 1, 2008 11:58 PM