Installing 2nd instance on multi-instance sql 2008 cluster
Posted on 2011-03-07
We are installing a mulit-instance sql server 2008 cluster. If we install the failover cluster on node a and then install the add node to node b - what is the next step? Should we add the second instance to node a even though we want it to run on node b (and then I guess change the preferred node in cluster admin) or do we add the second instance on node b and then install the add node on the other server? Alos, are there any other options to consider - possibly installing both instances first and then installing the add node feature of both afterwards? Are there any other things to consider with this type of install?