SQL Server R2 Super Detailed installation graphics tutorial and problem solving

Problem point:

1, in order to SQL Server and MySQL security, it is recommended to run low database permissions. Disable remote access to ports 1433 and 3306, and so on.

2. The installation process prompts Windows Firewall warning: Turn off the firewall's "public configuration"

Installation

Second, burning the installation files into a CD-ROM or using a virtual CD-ROM to load, or directly unzip, open the installation files, the following interface appears

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

Here our operating system is Windows Server R2, which has the. NET Framework 3.5 By default SP1

Direct Point Determination

Select System Configuration Checker

There is one. NET application Security Warning, ignore.

Are you sure

Select the installation on the left, double-click "New Installation or add features to an existing installation" on the right

Are you sure

Enter the product key, next

Accept the license terms, next

Installation

Next

SQL Server Feature Installation

System operation and maintenance 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 the 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: Mixed mode

Set the password for the system administrator (SA)

Click Add to specify the SQL Server administrator login account for the operating system

Next

Next

Default, Next

Next

Next

Installation

Installing in progress

Installation complete, point off

System operation and maintenance 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 to connect to the database, the following interface appears

At this point, the SQL Server R2 database installation is complete

SQL Server R2 Super Detailed installation graphics tutorial and problem solving