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) ->
Go to the complete details ...