Microsoft SQL Server 2008 Installation Graphics Tutorial (Windows 7) _mssql2008

Microsoft SQL Server 2008

Installation Diagram (Windows 7)

FoxDie

April 17, 2010

Brief introduction

This article details the installation process for a complete Microsoft SQL Server 2008 on the Windows 7 operating system. Note: Microsoft SQL Server 2008 has some compatibility issues with the Windows 7 operating system, and you will need to install SP1 patches for Microsoft SQL Server 2008 after you complete the installation. The entire installation process is described in detail below.

Installation log

After starting Microsoft SQL 2008 Setup in the Windows7 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 to start the installation of SQL Server 2008.

Figure 1-1 Compatibility Issue Tips

After entering the SQL Server Installation Center, skip the "schedule" content and directly select "Install" in the list on the left side of the interface, as shown in Figure 1-2, and 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 to continue the installation.

Figure 1-4 Compatibility Issue Tips

After you go to the Installer Support Rules installation interface, the installer will automatically detect the basic support for the installation environment, and you will need to ensure that all conditions are passed before you can install the following, as shown in Figure 1-5. When all the tests have been completed, click "OK" to install the following.

Figure 1-5 Installer support rules

Next is the SQL Server2008 version selection and key filling, this article describes the installation process with "Enterprise evaluation" as an example, and 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 the Support Inspector, as shown in Figure 1-8, and click "Install" to continue the installation.

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

After the "Installer support rules" prosecution, go to the "Feature 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 "instance configuration," 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 based on the actual needs of users to make adjustments, this article does not delve into the impact of user settings, unified use of a user "Administrator", the impact of the subsequent log will be added to the explanation.

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, specify an administrator for Analysis Services configuration, as an example of the 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, the error and Usage report interface allows you to 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" to start the 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 details the full installation process for SQL Server 2008, but does not describe the SP1 patch installation instructions, it must be installed on a Windows 7 system, and the configuration of some services is not described in detail. Users can further study the SQL Server 2008 installation configuration in the light of their own needs.