Setting up SQL Server 2005 Active/Passive/Passive Node?

  • Is there any reason why there should be active/passive/passive cluster nodes in SQL 2005 running on Windows Server 2003?

    Does anyone know how to install SQL Server 2005 on the third passive node in an active/passive/passive stup?

    Current Scenario:

    I have SQL Server 2005 active/passive cluster (2 nodes) on Win2K3.

    I have added a third node (passive) to the cluster.

    I wanted to install SQL Server 2005 on the third (passive) node but it won't allow me to use the same Virtual server name (VirtualSQL) and the same cluster name (SQLCluster) as with the first two nodes. The installation wants unique names (different names) which I am reluctant to do.

    *** Does anyone know how to force this new installation to use the existing SQL cluster information? Please advise.

  • If you want to install a new instance into a cluster, you are going to need dedicated resources for that instance. The instance is going to need it's own cluster group, it's own virtual IP and name and it's own disk resources.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply