all groups > sql server connect > august 2004 >
You're in the

sql server connect

group:

SQL - clustered asp connection fails


SQL - clustered asp connection fails rl
8/18/2004 7:36:41 AM
sql server connect:
We have clustered IIS .asp pages that query our clustered SQL server. Thes
pages work when IIS is running on node 1 with SQL on either node. If the
web (IIS) is failed over to node 2 the .asp pages stop rendering and we get
404 errors. The .html pages work fine. On pages that have both .asp and
..html the html will work and the asp will not show up. All of these asp
pages require a connection to SQL to render correctly since the site works
perfectly on our first node and we are using a SAN so both nodes actually
see the exact same code we are thinking that the connection strings are
somehow being affected. Any suggestions on how we can fix this?

Richard Lovelace

Re: SQL - clustered asp connection fails SKG
8/18/2004 10:42:29 AM
rl, did u ever run IIS on Node2 only with Node1 not on line and was it
working.?


[quoted text, click to view]

RE: SQL - clustered asp connection fails rboyd NO[at]SPAM onlinemicrosoft.com
8/18/2004 4:09:35 PM
Can you make a connection using the ODBC admin tool to SQL Server from the
second node?

Check the client network utility (cliconfg.exe) on the node the node that
does not work for an invalid alias.

Rand
This posting is provided "as is" with no warranties and confers no rights.
AddThis Social Bookmark Button