SQL Server 2005, adding an instance to an existing failover cluster

Question

Is this support? I can't find the technet article that shows it is?

Currently I have a two-node failover cluster. My sql server 2005 SP4 has an innstance name of:

FASSRV1\INSTANCE1

I want to add a default instance to FASSRV1, is that possible?

Thanks,

Answer 1

Is this support? I can't find the technet article that shows it is?

Currently I have a two-node failover cluster. My sql server 2005 SP4 has an innstance name of:

FASSRV1\INSTANCE1

I want to add a default instance to FASSRV1, is that possible?

Thanks,

Answer 2

On a cluster you will have a dedicated name for each instance... So you can for sure add a new instance on the same cluster, but it will most likely then be FASSRV2... (Or whatever...)

Answer 3

Yes, it is possible, but you need to consider few things before installation like your hardware will be shared for both the instance and that can impact performance. Secondly i would suggest to make it Active-Active cluster having different storage drives.

below link can help in installation steps.

http://thomaspullen.wordpress.com/2009/06/04/installing-a-sql-server-2008-instance-into-an-existing-failover-cluster-of-2005-instances/

Answer 4

Duplicate Post : http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/f5e65a14-8fe5-48a1-b636-12c01c48652b

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!