Microsoft® SQL Server® 2012 Bible

747 Chapter 29: Clustering 29 of SQL Server 2012 instances that are used for reporting purposes. You would replicate your data o ...

74 8 Part V: Enterprise Data Management ■ (^3) : Failover or restart on critical server errors ■ Triggered level 1 or level 2 er ...

74 9 Chapter 29: Clustering 29 Server Role and Services Installation To confi gure Windows Server 2008 and Windows Server 2008R2 ...

750 Part V: Enterprise Data Management Click Next. The Choose a Server Authentication Certifi cate for SSL encryption screen op ...

751 Chapter 29: Clustering 29 FIGURE 29-2 Failover Cluster Manager option. To validate a cluster confi guration follow the next ...

752 Part V: Enterprise Data Management FIGURE 29-3 Select Servers or a Cluster screen. FIGURE 29-4 Validation progress window. c ...

753 Chapter 29: Clustering 29 When the validation is complete, the summary screen displays. In this screen you can review the Cl ...

754 Part V: Enterprise Data Management FIGURE 29-5 Access Point for Administering the Cluster screen. FIGURE 29-6 Newly created ...

755 Chapter 29: Clustering 29 While you have the list of cluster disks opened, it is highly recommended to change the name prope ...

756 Part V: Enterprise Data Management Installing SQL Server 2012 as a Clustered Instance Prior to performing the install of SQL ...

757 Chapter 29: Clustering 29 if you want to use distributed transactions with SQL Server, you need MSDTC installed. There are t ...

758 Part V: Enterprise Data Management Click Next. The Feature Rules screen opens. A third series of checks is performed to ver ...

759 Chapter 29: Clustering 29 instance. You do have the option to use DHCP; however, it is highly recommended specifying a reser ...

760 Part V: Enterprise Data Management Click Next. The Database Engine Confi guration screen opens. The Database Engine Confi g ...

761 Chapter 29: Clustering 29 FIGURE 29-10 Database Engine Confi guration Screen. Upon successful completion of the install proc ...

762 Part V: Enterprise Data Management FIGURE 29-11 SQL Server clustered resources. Configuring Microsoft Distributed Transactio ...

763 Chapter 29: Clustering 29 Figure 29-12 shows the Dependencies tab that will be brought online before MSDTC comes online. FIG ...

764 Part V: Enterprise Data Management When you add the MSDTC resource, you add it to the same cluster group as SQL; it will be ...

765 Chapter 29: Clustering 29 of problems. You’ll follow these steps for every additional node that you have in your cluster. Be ...

766 Part V: Enterprise Data Management Click Install. The Installation Wizard installs and adds the new node. When the install ...