Multiple instance on a node of a cluster

  • We have an active/active SQL 2000 cluster now. Our user would like to have a new SQL 2005 instance installed.

    I think we can install it from one node, but not 100% sure.

    If it is doable, what special attentions should I pay to?

    Many thanks in advance.

  • I think you just have to install the instance. Same as installing any instance on a cluster.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • You already might know this:

    you need:

    at least one more volume in the shared storage (SAN)

    one more IP Address

    one more network name

    Create the Storage Zoning etc..

    On Node1 assign the letter to the Volume.

    Set the Cluster Service and disk Drive in SYSTEM and shutdown NODE1

    On NOde 2 Verify new volume and assign Volume letter if not present.

    Repeat the above step for node2 and shutdown node 2

    Node1--Create Cluster Group adn add Volume.

    Node 2-- you will be able to move the Cluster Group with the new volume..from node 1 to node 2.

    Install a new SQL Server instance using the new volume in cluster, providing a new IP Address and a new Network Name

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

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