Microsoft® SQL Server® 2012 Bible

765

Chapter 29: Clustering

29

of problems. You’ll follow these steps for every additional node that you have in your

cluster.

Before performing an install to add a new node to an existing SQL Server 2012 failover

cluster, you need to ensure that the node is part of the Windows Cluster and that all the

storage is viewable. You should also run a validation check to be sure that there are no

errors that may impact availability.

Installing SQL Server 2012 on additional nodes requires a lot less user interaction

because the vast majority of the information was provided when the original install

took place.

To add a node to an existing SQL Server 2012 failover cluster, follow the next steps:

1. Open your SQL Server 2012 installation media and run Setup.exe. The SQL Server
   2012 Installation Center screen opens.


2. Select Installation on the left side, and then click Add Node to a SQL Server
   Failover Cluster from the options on the right.
   The Cluster Node Confi guration screen opens. On this screen all currently installed
   SQL Server 2012 instances on the cluster along with the possible owning nodes are
   listed.


3. From the drop-down select the instance that you want to add this node for.


4. Click Next. The Cluster Network Confi guration screen opens. On this screen the
   existing network settings for the instance that you work with are listed. You
   cannot make changes on this screen.


5. Click Next. The Service Accounts screen opens. As a security measure on the
   Service Accounts screen, you are required to re-enter the passwords for the SQL
   Server Database Engine and SQL Server Agent accounts that the services are
   currently running under


6. Click Next. The Add Node Rules screen opens. The Setup Wizard performs a series of
   checks to confi rm that you are not trying to exceed the maximum number of nodes
   permitted for the SQL Server 2012 edition, and that the node you are trying to add
   is ready for the install.


7. Click Next. The Ready to Add Node screen opens. This fi nal screen shows a summary
   of the install actions to be performed and displays the path to the confi guration
   fi le that will be used to add the node.

The confi guration fi le that is generated can be copied to another node to quickly add that node as an owner for this

SQL Server 2012 instance using an elevated command prompt and running the following command:

setup.exe / ConfigurationFile=Myconfigurationfile.ini

c29.indd 765c29.indd 765 7/31/2012 9:52:02 AM7/31/2012 9:52:02 AM

http://www.it-ebooks.info