InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 21:46:05 GMT20http://www.sqlservercentral.com/Forums/Topic1410376-1549-1.aspx[quote][b]foxxo (1/23/2013)[/b][hr]Also, you need to install the 2nd instance from the 1st node, then fail it over. [/quote]Actually, no you don't![quote][b]chandrakant_gaurav (1/23/2013)[/b][hr]Yes correct. Existing cluster needs to remain untouched and cluster should become active-active.[/quote]Ensure you present any storage for the new instance to both nodes, it's probably easier (and I prefer too) install the new instance on the currently passive node which will then make it active. You may then simply run the add node wizard on the partner node that has the original instance running.Wed, 23 Jan 2013 05:35:29 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1410376-1549-1.aspxIt should be fairly straightforward. Make sure you're licenced for the extra running hardware. Brent Ozar has a screenshotted installhttp://www.sysads.co.uk/2012/02/add-additonal-sql-instance-to-existing-sql-server-2008-r2-cluster/Also, you need to install the 2nd instance from the 1st node, then fail it over. Make sure your SQL max memory settings are suitable (either change them through a SQL agent job on SQL startup or ensure both instance will fit in RAM on the same node)Wed, 23 Jan 2013 01:40:08 GMTfoxxohttp://www.sqlservercentral.com/Forums/Topic1410376-1549-1.aspxYes correct. Existing cluster needs to remain untouched and cluster should become active-active.Wed, 23 Jan 2013 01:22:40 GMTchandrakant_gauravhttp://www.sqlservercentral.com/Forums/Topic1410376-1549-1.aspxIsn't the definition of an active/active cluster one that runs a separate instance on each node, each with their own resource groups? So you are wanting to go from active/passive to active/active.Wed, 23 Jan 2013 01:18:46 GMTfoxxohttp://www.sqlservercentral.com/Forums/Topic1410376-1549-1.aspxFriends,I am exploring an option to create SQL cluster with active/passive node on an already existing cluster.Here is the scenario:Existing: Server 1 is Active and server 2 is passiveRequired: I need to add discs and on separate resource group I want to create Server 2 as active with different SQL server instance, of course, and Server 1 will be passive node for this cluster.I have done a lot of research on this and I think is it possible. Please provide some points to consider before going ahead with this plan, I cant afford to mess up on this one.Response is much appreciated.Wed, 23 Jan 2013 00:35:16 GMTchandrakant_gaurav