sql2008 Installation Tutorial SQL Server 2008 R2 installation Diagram _mssql2008

First, enter the installation process

Insert the SQL Server 2008 R2 installation CD, and the SQL Server installation center appears after Autorun.

Here we install a default instance of SQL Server on this computer, so perform the following steps:

1, select "Install" in the left directory tree.

2. In the Select item on the right, select the 1th item "New Installation or add functionality to an existing installation", and then enter the installer.

Second, the installation of the preparation process

1. Installation program Support rules

In this preparation process, the installer will first scan some of the information on this machine to determine that no exception will occur during installation. If you find problems in the scan, you must fix the problems before you can re-run setup to install them.

2. Product Key

3. License Terms

4, the installation program supporting files

In this step, Setup needs to install some of the necessary components on this machine.

Third, function selection and configuration

Next, the SQL Server program is formally installed.

1. Installation program Support rules

This step appears to be the same as in the preparation process, scanning the native to prevent exceptions during the installation process. Now is not the repetition of the previous steps, from the following figure it is obvious that this scan is more precise, scanning more content.

In this step, you must not ignore the "Windows Firewall" warning, because if you install SQL Server on the Windows2008 operating system, the operating system does not automatically open the TCP1433 port on the firewall. This issue will be mentioned in a later article.

2, set the role

Here are 3 options to choose from. We selected "SQL Server feature installation."

3. Function selection

Here, we click on the "Select All" button, you will find a few more items on the left tree: After the install rule, there is an extra instance configuration, with server configuration, Database engine configuration, Analysis Services configuration, and Reporting Services Configuration ".

Note : If you only need to install the SQL Server client (SQL Server Native Client), simply select the Client tool connection (clients tools connectivity).

　　Note : If you only need to install administrative tools, simply select a basic or complete module.

4. Installation rules

Here again, scanning the local, the contents of the scan with the last time and different.

5. Instance Configuration

We install a default instance here. The system automatically names this instance as: MSSQLServer.

6. Disk Space Requirements

You can see from here that the full functionality of installing SQL Server requires 5485MB of disk space.

7, server Configuration

Here, you first configure the server's service account, that is, which account the operating system uses to start the appropriate service. For the sake of convenience, we chose to "use the same account for all SQL Server services".

Next, the device collation is also needed.

8. Database Engine Configuration

The database engine is set up with 3 main items.

9. Analysis Services Configuration

10. Reporting Services Configuration

11, Error Reporting

12. Installation Configuration Rules

Iv. Installation Progress

Once you have finished selecting and configuring the above features, you are ready to install.

First, let's confirm the installation options.

After the confirmation, click the "Install" button, the machine's hard drive will begin to turn wildly. In the case of a new installation, this process will take approximately 1.5 hours (depending on the speed of the disk).

Until the end, there was this picture, finally finished.

After the installation is complete, the summary log is saved at the following location:< the data root directory >\100\setup bootstrap\log\<yyyymmdd_hhmmss>\sumary_<pc name>_< Yyyymmdd_hhmmss>.txt

The system-configured check report is saved in the following location::< the data root directory >\100\setup Bootstrap\log\<yyyymmdd_hhmmss>\systemconfigurationcheck_ Report.htm