Install SQL Server 2005 in active/active clustering.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chen - 23 May 2006 20:13 GMT

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!
Chen

Reply to this Message

Geoff N. Hiten - 23 May 2006 20:35 GMT

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.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

.

> Hi,
> Our current production databases use the SQL Server 2000 EE, two named
[quoted text clipped - 10 lines]
> Regards!
> Chen

Reply to this Message