SQL Server R2 Super Detailed installation graphics tutorial and problem solving

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.