Microsoft SQL Server 2008 R2 Unleashed- P25: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 | 194 CHAPTER 8 Installing SQL Server 2008 and the System Configuration Checker. You typically first want to run the System Configuration Checker to confirm that your system meets the minimum hardware and software requirements for installing SQL Server 2008. Click on the link for the System Configuration Checker to bring up the screen shown in Figure . This is essentially the Setup Support Rules screen that also runs during the actual installation. It s better to find out now if there will be any issues with the installation before you get into the actual installation. FIGURE System Configuration Checker window When the SCC scan is complete overall status of the check is detailed at the top of the main window. You can click the Show Details button to view a detailed report of the checks performed. This report notes any issues found. If any checks fail or a warning is raised click the hyperlink in the Status column for more detailed report with specifics and suggestions for resolution. Click the View Detailed Report link to see the SCC results in an HTML report format which is also saved to a file see Figure . After you verify that the system configuration is sufficient to support the SQL Server 2008 installation click OK to go back to the SQL Server Installation Center. Then click on the Installation option in the menu on the left of the SQL Server Installation Center. This brings up the installation options. To install a new instance of SQL Server select the New Installation or Add Features to an Existing Installation option as shown in Figure . Download from Installation Walkthrough 195 FIGURE System Configuration Checker HTML report. FIGURE SQL Server Installation menu. 8 Download from 196 CHAPTER 8 Installing SQL Server 2008 NOTE The following installation steps and screenshots are based on the installation of SQL Server 2008 R2. For SQL Server 2008 installations the order of the install screens and options
