Windows2008 system Microsoft SQL Server 2008 Installation Diagram Tutorial

After starting Microsoft SQL 2008 Setup in the Windows2008 operating system, the System Compatibility Assistant prompts the software for compatibility issues and must install the SP1 patch to run after the installation is complete, as shown in Figure 1-1. Here, select “ Run program ” start SQL Server 2008 installation.

Figure 1-1 Compatibility Issue Tips

After entering the SQL Server Installation Center, skip “ plan ” content, directly select the “ installation &rdquo in the list on the left side of the interface; as shown in Figure 1-2, go to the installation list selection.

Figure 1-2sql Server Installation Center-planning

As shown in Figure 1-3, enter the SQL Server installation center-after the installation interface, the list on the right shows different installation options. This article describes the entire installation process as an example of a new installation, so select the first installation option “ new SQL Server standalone installation or existing installation add feature ”.

Figure 1-3 SQL Server Installation Center-installation

After you select a new installation, the System Program Compatibility Assistant prompts you again for compatibility issues, as shown in Figure 1-4. Select “ Run program ” continue installation.

Figure 1-4 Compatibility Issue Tips

After entering the “ installer support rules ” installation interface, the installer will automatically detect the basic support condition of the installation environment and need to ensure that all conditions are passed before the following installation can take place, as shown in Figure 1-5. When all the tests have been completed, click “ OK ” do the following installation.

Figure 1-5 Installer support rules

Next is SQL Server2008 version selection and key filling, this article is “ Enterprise evaluation” As an example of the installation process, the key can be purchased from Microsoft Official, as shown in Figure 1-6.

Figure 1-6 Product Key

In the license Terms interface, you need to accept the Microsoft Software License terms to install SQL Server2008, as shown in Figure 1-7.

Figure 1-7 License Terms

The next step is to install support inspectors, as shown in Figure 1-8, click “ Install ” continue to install.

Figure 1-8 Installer support file

As shown in Figure 1-9, the following installation cannot continue until all detections have been passed. If an error occurs, you need to correct all failures before you install.

Figure 1-9 Installer support rules

Through the “ installer support rules ” after the inspection into the “ function selection ” interface, as shown in Figure 1-10. Here, select the SQL Server features you want to install, and the installation path. Recommendation: Because data and operation log files can be extremely large, choose the installation path carefully, or select a proprietary save path when you build the database.

Figure 1-10 Feature Selection

As shown in Figure 1-11, the next step is the “ instance configuration &rdquo, where the default ID and path are selected.

Figure 1-11 Instance Configuration

The disk usage is displayed after the installation Content selection is complete, and can be adjusted to disk space, as shown in Figure 1-12.

Figure 1-12 Disk Space requirements

As shown in Figure 1-13, in the server configuration, you need to specify a legitimate account for the various services. Note: Here needs to be adjusted according to the actual needs of users, this article does not delve into the impact of user settings, unified use of a user “ Administrator&rdquo, the resulting impact will be supplemented in future journals.

Figure 1-13 Server Configuration

The next step is authentication at the time of database logon, where you need to specify an administrator for SQL Server, as an example of the system administrator, as shown in Figure 1-14. Recommendation: When installing SQL Server on a server, it is safe to establish an independent user for management.

Figure 1-14 Database Engine configuration

As shown in Figure 1-15, the “ Analysis Services Configuration ” Specify administrators, as an example of a system administrator. Recommendation: When installing SQL Server on a server, it is safe to establish an independent user for management.

Figure 1-15 Analysis Services Configuration

Select the default mode in the report service configuration, and the user can choose according to the requirements, as shown in Figure 1-16.

Figure 1-16 Reporting Services Configuration

As shown in Figure 1-17,“ error and Usage report ” interface, you can choose whether to send the error report to Microsoft.

Figure 1-17 Error and usage reports

Finally, according to the functional configuration selection of the environmental inspection again, as shown in Figure 1-18.

Figure 1-18 Installation Rules

After the inspection, the software will list all the configuration information and confirm the installation last time, as shown in Figure 1-19. Click “ Install ” start SQL Server installation.

Figure 1-19 Preparing to install

Depending on the hardware environment, the installation process can last for 10-30 minutes, as shown in Figure 1-20.

Figure 1-20 Installation Progress

As shown in Figure 1-21, when the installation is complete, SQL Server lists the feature installation states.

Figure 1-21 Installation Progress completed

As shown in Figure 1-22, SQL Server 2008 completes the installation and saves the installation log under the specified path.

Figure 1-22 Completing the installation

Summarize

This article describes in detail the full installation process for SQL Server 2008. Users can further study the SQL Server 2008 installation configuration in the light of their own needs.