OK, here's the problem:
Our local intranet has a bunch of web applications that access data on a server (running MSSQL 2K). We're currently creating another synchronous server so that if one goes down, we can switch to the other without losing any data. What we'd like to do is have the local websites automatically redirect to one server if the other one isn't available (crashed, down for maintenance, etc.) when accessing the data. The connection string used to access this server is stored in the webapp.
The question is, is there any way to alter the connection strings in the pages without going through every page and changing it manually? Is there a way to check whether a server is available before it attempts to connect? Any help would be appreciated.
Our local intranet has a bunch of web applications that access data on a server (running MSSQL 2K). We're currently creating another synchronous server so that if one goes down, we can switch to the other without losing any data. What we'd like to do is have the local websites automatically redirect to one server if the other one isn't available (crashed, down for maintenance, etc.) when accessing the data. The connection string used to access this server is stored in the webapp.
The question is, is there any way to alter the connection strings in the pages without going through every page and changing it manually? Is there a way to check whether a server is available before it attempts to connect? Any help would be appreciated.