SQL Server 2008 R2 detailed installation Graphics tutorial _mssql2008

First, download the SQL Server 2008 R2 installation files

Cn_sql_server_2008_r2_enterprise_x86_x64_ia64_dvd_522233.iso

Second, the installation of the file into a CD-ROM or virtual CD-ROM loading, or directly decompression, open the installation file, the following interface appears

Installing SQL Server 2008 R2 requires the. NET Framework 3.5 SP1 Support

Here our operating system is Windows Server 2008 R2, and the. NET Framework 3.5 has been brought in by default SP1

Direct Point Determination

Select System Configuration Checker

There's one. NET application security, ignore it.

Are you sure

Select Install on the left, double-click "New Installation or add feature to existing Installation" on the right

Are you sure

Enter Product Key, next

Accept the license terms and next

Installation

Next

SQL Server Feature Installation

System Yun-wei www.osyunwei.com warm reminder: qihang01 original content copyright, reproduced please indicate the source and the original link

Select the components you want, click here to choose All, install all components

Select Installation path, next

Next

Default instance, next

Next

Service account settings, choose to use the same account for all SQL Server services

Enter the operating system's account name and password to determine

Next

Authentication Mode: Blending mode

Set the password for the system administrator (SA)

Point add, specify SQL Server administrator for operating system login account

Next

Next

Default, Next

Next

Next

Installation

In the process of being installed

Installation complete, point off

System Yun-wei www.osyunwei.com warm reminder: qihang01 original content copyright, reproduced please indicate the source and the original link

In the Windows Start menu, open the Database management tool

Enter the login name and password, connect the database, and the following interface appears

At this point, the SQL Server 2008 R2 Database installation is complete

Cloud-dwelling Community small note:

For SQL Server and MySQL security, the database is recommended to run with low privileges. Prohibit remote access to ports 1433 and 3306.