Home / server / Questions / 64950
Accepted
Jason Kleban
Asked: 2009-09-14 10:31:42 +0800 CST

SQL 2005 Active/Active Cluster - Additional Instance Setup

  • 772

I'm installing a new instance of SQL 2005 on an existing cluster. From what I've read, I should be able to install that new instance on the same cluster name with a new instance name. Same IP, different port, same server name.

But instead, the setup is only allowing me to create a brand new sql virtual server name, new IP.

Is having two sql groups on the same cluster with the same virtual server name and IP, just different port and instance name possible?

Thanks.

windows-server-2003

3 Answers

  1. No, each instance needs its own IP address and network name.

    And at least one of them needs to be a named instance.

    • 0
  2. Best Answer

    No. Think about it.

    On failover, do you want both instances to go? By failover, it does not mean failure but any event that needs the virtual instance to be running on another node.

    What about the resources owned by an instance? Assuming that one fails over, do you want it to take the disks of the other instance with it too?

    It makes no sense to have mutiple instances per virtual server. It's a recipe for disaster.

    • 0

  3. Each instance needs its own LUNs, network name, IP address, and resource group.

    This is so that each instance is failed over independently from the others instances.

    • 0