0

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.

3 Answers 3

0

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.

2
  • Each instance has its own dedicated LUNs. does that change anything? Sep 13, 2009 at 19:20
  • @Jason: no. The virtual server owns the resources. This means all LUNs on that IP address
    – gbn
    Sep 13, 2009 at 19:39
0

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

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

0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .