SQL Server 2008 R2 Installation Configuration method Graphics Tutorial _mssql2008

Microsoft SQL Server 2008 R2 installation Diagram

Tools:

SQL Server 2008 R2 installation CD or mirrored ISO

The preparation process for installation:

Insert the 2008 R2 installation CD or load a mirrored ISO file, skip the "schedule" content after entering SQL Server installation Center, and directly select "Install" in the list on the left side of the interface

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 the figure. When all the tests have been completed, click "OK" to install the following.

Next is SQL Server2008 version selection and key fill

License Terms

Install program support files, click "Install" to continue the installation.

Feature Selection and configuration:

Next, the SQL Server program is formally installed.

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.

The following installation cannot continue until all detections have been passed. If an error occurs, you need to correct all failures before you install.

Setting roles

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

After the "Installer support rules" prosecution, go to the "Feature Selection" interface, where you 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. Let's click the "Select All" button, you'll 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 in the back of disk space requirements. Services Configuration ".

Installation rules

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

Next is "instance configuration," where you select the default ID and path. The system automatically names this instance as: MSSQLServer.

After you finish selecting the installation content, you will see disk usage, depending on your disk space, and you can view that the full functionality of the SQL Server installation requires 5485MB of disk space.

In a server configuration, you need to specify a legitimate account for a variety of 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"

Next, the device collation is also needed.

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 the figure. Recommendation: When installing SQL Server on a server, it is safe to establish an independent user for management. The database engine is set up with 3 main items.

Analysis Services Configuration:

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.

Reporting Services Configuration:

Select the default mode in the report service configuration, and the user can choose according to the requirements, as shown in

Error reporting, the interface can choose whether to send error reports to Microsoft.

Install the configuration rules, finally, according to the functional configuration of the selection of environmental inspection again

End

Official installation:

After the inspection, the software will list all the configuration information, the last confirmation of installation, as shown in the figure. Click "Install" to start the SQL Server installation.

After the confirmation, click the "Install" button, the machine's hard drive will begin to turn wildly. Depending on the hardware environment, the installation process can last for 10-30 minutes and, if it is a new installation, it takes about 1.5 hours.

Until the end, there was this picture, finally finished. As shown in the figure, SQL Server 2008 completes the installation and saves the installation log under the specified path.

Your problem is not solved!

Wonderful topic Sharing: SQL Server Installation Tutorial manual

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.