Microsoft SQL Server 2008 R2 Unleashed- P74:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 674 CHAPTER 21 SQL Server Clustering directories for the root and subfolders and the FILESTREAM options. Needless to say the Data root directory is on the S drive. FIGURE Specifying Cluster Security Policy Server Config and Database Engine Config. You then are prompted through the Analysis Services Configuration and Reporting Services Configuration dialogs. Your Analysis Services Data directories are within a subfolder of S OLAP . At this point you have worked your way down to the Cluster Installation Rules check to determine if everything specified to this point is correct. Figure shows this rules check passing status a summary of what is about to be done and the location of the configuration file and path that can be used later if you are doing command-line installs of new nodes in the cluster. A box appears around this configuration file path location at the bottom right of the Ready to Install dialog to show you where it is being created if needed . The next step is to click on the Install button. The setup process installs SQL Server binaries locally on each node in the cluster that is in C Program Files Microsoft SQL Server . The database files for the master model tempdb and msdb databases are placed on the S drive in this example. This is the shared disk location that must be available to all nodes in the SQL Server cluster. When the process is complete you can pop over into the Cluster Administrator and see all the resources just installed within the failover cluster. This is not highly available yet because you have completed only one node of the two-node failover cluster. But as you Download from Installing SQL Server Clustering 675 FIGURE Cluster Installation Rules check and Ready to Install dialog. 21 can see in Figure the SQL Server components have been successfully installed and are usable within the cluster. Adding the next node and any more subsequent nodes to the cluster will make this configuration highly
