August 17, 2004 at 2:09 pm
Has anyone clustered a web site using .asp pages connected to a SQL database and gotten it to work correctly?
We have a clustered web site using asp pages that are connected to a clustered SQL server (physically the same two nodes). When running IIS on node 1 with SQL running on either node 1 or node 2 the asp pages work fine. When IIS is on node 2 with SQL running on either node the asp pages return a 404 page not found error. Also with IIS on node 2 the pages with html run fine and the pages with a combination of html and asp render the html but not the asp. I have sent Veritas our config files and they tell us that our nodes are corretly configured and the issue lies with the asp. We have also heard that SQL has a connection string pool that discards the strings when a failover or switch occcurs. Has anyone seen this before? Can anyone offer any advice?
Thanks
August 17, 2004 at 2:37 pm
A connection pool is a set of SQL Server connections maintained by ADO/ ADO.NET and is used to communicate with SQL Server. In SQL Server side, TCP/IP has to be enabled. Other than that, I am not aware of anything else SQL Server has to be configured.
You may compare the registry settting on both nodes to make sure your ASP registry settings have connection pooling enabled.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply