September 26, 2003 at 7:47 am
We want to install a SQL 2000 cluster on servers that have SQL 7 installed AND have MSCS working (with SQL 7 not being part of the cluster). We're trying to minimize downtime. Can we install a SQL 2000 cluster beside the SQL 7 instance? I understand the name of the Sql cluster will need to be different from the MSCS cluster. I assume all our web code with DB access will need to have connections/DSNs updated to reflect the new SQL cluster name? (OS is 2000 Advanced Server)
September 26, 2003 at 8:15 am
Don't do that. Install SQL Server 2000 will install MDAC 2.6 which SQL Server 7.0 cluster can't run properly in this MDAC version.
September 26, 2003 at 8:26 am
Actually we already installed SQL 2000 as an instance on one node besides the SQL 7 instance. (which is the default). Things look okay. I just want to make sure SQL 2000 is clustered with this install. SQL 7 was never clustered and thus we have to manually do some synchronizing whenever our MSCS cluster fails over to the 2nd node (active-passive)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply