Install SQL Server 2005 in active/active clustering. -- sql server clustering

Chen
5/23/2006 12:13:02 PM

Hi,
Our current production databases use the SQL Server 2000 EE, two named
instances with active/passive clustering. I remembered when I install the
named instances, I run cliconfg.exe first, create server alias in SQL Server
client Network Utility dialog box, then run SQL Server 2000 setup.
Now I need install SQL Server 2005 EE in new active/active clustering node
(64 bit) with two named instances, my question are:
1) Do I need run cliconfg.exe first like install at SQL Server 2000?
2) Since this is active/active clustering, so I need install first instance
in node1 and second instance in node2, am I right?
Regards!

Geoff N. Hiten
5/23/2006 3:35:14 PM

You do not need the aliases for SQL 2005 cluster installation on Windows
2003. They were there to work around a Slammer defense in Windows 2003.
SQL 2005 is not vulnerable to slammer.

Each instance installation needs to be run from the node that currently owns
the "anchor" disk resource for that instance. The installer (and service
pack installer and hotfix installer) are all cluster-aware and will install
the instance to all targeted nodes.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

..
[quoted text, click to view]

sql server clustering : Install SQL Server 2005 in active/active clustering.