- What's New for Installation with SQL Server 2008?
- Preplanning and Preparing a SQL Server 2008 Server Database Engine Installation
- Gathering Additional Information Necessary to Proceed
- Installing a Clean Version of SQL Server 2008
- Upgrading the Database Engine to SQL Server 2008
- Finalizing the SQL Server 2008 Installation or Upgrade
- Managing SQL Server 2008 Installations
- Best Practices
Installing a Clean Version of SQL Server 2008
The following sections depict the step-by-step instructions for installing a clean version of the SQL Server 2008 Database Engine feature including supplementary subfeatures such as SQL Server Replication, Full-Text Search, Integration Services, and Shared Components.
Log in to the server with administrative privileges and insert the SQL Server 2008 media. Autorun should launch the SQL Server 2008 Installation Center landing page; otherwise, click Setup.exe
On the SQL Server Installation Center landing page, first select the Installation page, and then click the New SQL Server Stand-alone Installation or Add Features to an Existing Installation link, as displayed in Figure 1.1.
Figure 1.1 Performing a new SQL Server stand-alone installation.
On the Setup Support Rules page, review the outcome of the System Configuration Checker. Ensure that all tests associated with the operation passed without any failures, warnings, or skipped elements. Alternatively, you can review a standard or comprehensive report by selecting the Show Details button or View Detailed Report. To continue with the installation, click OK, as illustrated in Figure 1.2.
Figure 1.2 Reviewing potential problems identified with the Setup Support Rules.
- On the Product Key page, enter the SQL Server Product Key and click Next.
- On the License Agreement page, Accept the Licensing Terms, and then click Next.
- On the Setup Support Files page, the wizard will prompt whether or not additional setup support files are required for the installation. If additional files are required, review the status of the files required, and then click Install.
The Setup Support Rules page will be displayed again and will identify any outstanding items that may hinder the installation process associated with the SQL Server installation. Review and correct failures and warnings before commencing the installation. If failures are not displayed, click Next to start the installation. Once any outstanding installation are complete, review the details, and then click Next.
On the Feature Selection page, select the desired features to be installed and provide the path for the Shared Feature Directory. For this example, the Database Engine Services, SQL Server Replication, Full-Text Search, and appropriate Shared Features such as Integration Services and the Management Tools have been selected. Click Next to proceed as illustrated in Figure 1.3.
Figure 1.3 Specifying the SQL Server features to be installed.
On the Instance Configuration page, specify the Name and Instance ID for the SQL Server installation. The options include either the Default Instance name, which is MSSQLServer, or a Named Instance. In addition, click the ellipsis button in the Instance Root Directory area and specify the path for the installation. Click Next as displayed in Figure 1.4.
Figure 1.4 Configuring the SQL Server instance.
- The next page is the Disk Space Requirements. Review the disk space summary for the SQL Server components and features selected to be installed, and then click Next.
The Server Configuration page includes configuration settings for both Service Accounts and Collation. On the Service Accounts tab, enter a valid low-privilege service account name and password for each service account. Next, specify the Startup Type for each service account listed, as illustrated in Figure 1.5. Options include Automatic, Manual or Disabled. Before proceeding to the next step, click the Collation tab,
Figure 1.5 Specifying the SQL Server service accounts.
- On the Collation tab, enter the desired collation option for the Database Engine. It is possible to change default collation settings used by the Database Engine and Analysis Services for language and sorting by selecting Customize. Click Next to continue.
The Database Engine Configuration page consists of three tabs. The tabs include Account Provisioning, Data Directories, and FILESTREAM. On the first tab, in the Account Provisioning section, specify the Authentication Mode, which consists of either Windows Authentication Mode or Mixed Mode (SQL Server authentication and Windows authentication). If mixed mode is selected, enter and confirm the password for the Built-in SQL Server administrator account. The next step is to provision a SQL Server Administrator by either selecting the option Add Current User or clicking Add and specifying a SQL Server administrator account.
The second tab, Data Directories, located still within the Database Engine Configuration page, is used for specifying the location of the default directories associated with the installation of this SQL Server instance. The directories include Data Root Directory, System Database Directory, User Database Directory, User Database Log Directory, TempDB Directory, TempDB Log Directory, and Backup Directory. Either maintain the default directories or specify a new directory for performance and availability.
- The final tab on the Database Engine Configuration page is FILESTREAM. Here, decide whether you want to enable FILESTREAM. If FILESTREAM is enabled, additional parameters must be entered such as Enable FILESTREAM for File I/O Streaming Access, Windows Share Name, and whether to allow remote clients to have streaming access to FILESTREAM data. Click Next to proceed.
- On the Error and Usage Reporting page, help Microsoft improve SQL Server features and services by sending error reports and feature usage to Microsoft. Specify the level of participation, and then click Next.
- The final check will take place to ensure that the installation process will not be blocked. On the Installation Rules page, review for any outstanding errors or warnings and then click Next to continue.
- Before commencing the SQL Server 2008 Installation, review the features to be installed on the Ready to Install page, and then click Install.
- When the installation process starts, you can monitor its progress accordingly. When the installation setup completes, review the success status based on each SQL Server feature and then click Next.
- On the Complete page, review the location of the SQL Server summary upgrade log file and additional items, which can be found in the supplemental information section. Click Close to finalize the installation.
- To conduct post-installation tasks, review the upcoming section “Finalizing the SQL Server 2008 Installation or Upgrade” in this chapter.