Installing SQL Server R2

The so-called database refers to: according to a certain data structure to organize the storage and management of the warehouse.

The database is mainly divided into the following categories:

Hierarchical type: Generally used in enterprise organization structure.

Mesh: Represents a complex relationship between objects.

Relational: A relationship is a two-dimensional table (with columns).

Let's install it as a typical SQL Server in a relational database:

SQL Server R2 is mainly divided into the Standard Edition, Enterprise Edition, Web version and development version of the four versions, the following is the enterprise version of the installation to explain:

SQL Server R2 Enterprise Edition is only installed on the server-side operating system, and below we start installing on Windows Server R2:

1. Install SQL Server R2 first to install. NET Framework3.5:

Open Server Manager:

650) this.width=650; "height=" 449 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/3D/ Wkiom1uc8inrwee5aahygmcwapw920.jpg "border=" 0 "/>

Mouse click function:

650) this.width=650; "height=" 449 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/3D/ Wkiom1uc8inhbad5aafnzxu5t-0857.jpg "border=" 0 "/>

Click Add Features:

650) this.width=650; "height=" 476 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/5C/3D/wKiom1Uc8IrzPuQ-AAHl_ Ulp4gi997.jpg "border=" 0 "/>

Select the. NET Framework3.5 Feature:

650) this.width=650; "height=" 326 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/5C/3D/wKiom1Uc8Iqh_ Gw8aafy7h7-1gw908.jpg "border=" 0 "/>

Click to add the required role services:

650) this.width=650; "height=" 476 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/5C/3D/wKiom1Uc8Ivz5EWfAAHya-we_ H0552.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 476 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/38/ Wkiol1uc8cqql7n3aahaxakrknw046.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 476 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/3D/ Wkiom1uc8iyhdkeoaagj5jiqavy624.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 345 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/3D/ Wkiom1uc8izzcan3aafvycrgb4a193.jpg "border=" 0 "/>

Click Install:

650) this.width=650; "height=" 476 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/3D/ Wkiom1uc8i3rjv3faaebfw8iiw4849.jpg "border=" 0 "/>

To start the installation:

650) this.width=650; "height=" 476 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/38/ Wkiol1uc8czyfvwgaagu497j8gm139.jpg "border=" 0 "/>

Installation is successful, click Close.

2. Open My Computer:

650) this.width=650; "height=" 461 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/38/ Wkiol1uc8c2qgkglaagu8r2fgng453.jpg "border=" 0 "/>

Right-click the DVD drive, tap install from media or allow program:

650) this.width=650; "height=" 484 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/38/ Wkiol1uc8c2gummpaajpfllcyu8199.jpg "border=" 0 "/>

The system gives us a pop-up of the SQL Server Installation Center, and we click Install:

650) this.width=650; "height=" 484 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/38/ Wkiol1uc8c7sqmmnaag2zgeuygi616.jpg "border=" 0 "/>

Because we are installing for the first time, we choose a new installation here:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/38/wKioL1Uc8c6iKh0HAAEYg60iZ_ C119.jpg "border=" 0 "/>

The installer is checking the rules and we wait a moment:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/38/ Wkiol1uc8c6ds75iaaesbazsak0986.jpg "border=" 0 "/>

The system tells us that the detection is complete and has passed (note that if there are options that are not passed here, be sure to return the fix), we click OK:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/38/ Wkiol1uc8c-cjoxjaafxzilchks857.jpg "border=" 0 "/>

Here the system lets us enter the product key such as yourselves, we enter and then click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/3D/ Wkiom1uc8jciuapcaah6lwy7eom703.jpg "border=" 0 "/>

Here Microsoft asks if we accept the license terms, we select Accept, and then click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/3D/ Wkiom1uc8jcy9ueqaae8jgdcvcu824.jpg "border=" 0 "/>

Here we click Install:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/3D/ Wkiom1uc8jdquxehaae11q485ry222.jpg "border=" 0 "/>

Setup once again checks the installation rules:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/3D/ Wkiom1uc8jhiiutiaajet81emus881.jpg "border=" 0 "/>

Note There can be no failure here, we click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/38/ Wkiol1uc8ddrc50qaagvg1cje1q761.jpg "border=" 0 "/>

Here we select the SQL Server feature installation and then click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/3D/wKiom1Uc8JKw4hJyAAH4d7_ 0ixo259.jpg "border=" 0 "/>

Here we cancel the check of the report service, all other tick, then click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/3D/ Wkiom1uc8jlzthheaafsfwoqmu8086.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/38/ Wkiol1uc8dgjkataaahmmofu7jw723.jpg "border=" 0 "/>

Here we select the default instance and click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/3D/ Wkiom1uc8jpi9hp1aafr7o4blqa871.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/38/ Wkiol1uc8dlcmnjiaahhcg1d7oc359.jpg "border=" 0 "/>

Here, let's configure the server, we choose to use the same account for all SQL Server:

650) this.width=650; "height=" 192 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/38/ Wkiol1uc8dkqxz6jaadztgstulq327.jpg "border=" 0 "/>

Enter your user name and password:

650) this.width=650; "height=" 192 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/38/ Wkiol1uc8dpczxm4aadmdmcr6aa494.jpg "border=" 0 "/>

Click OK:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/38/ Wkiol1uc8doyjspuaah7cpzpgxe006.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/3D/ Wkiom1uc8jtjoascaahsfxhhvhg018.jpg "border=" 0 "/>

Here the system lets us choose the authentication mode, because we are the experimental environment, so directly select Windows authentication:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/3D/ Wkiom1uc8jtzhixqaahsfxhhvhg410.jpg "border=" 0 "/>

Click Add Current User:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/3D/ Wkiom1uc8jwgmwwzaah-bjj3-de849.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/38/ Wkiol1uc8dtbhukqaagootqcq5g968.jpg "border=" 0 "/>

Here I we choose to add the current user, click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/38/ Wkiol1uc8dxqqkcbaahjjbeoays946.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/3D/wKiom1Uc8JbQYoAFAAFU1P1I_ Vg169.jpg "border=" 0 "/>

Click Next:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/3D/ Wkiom1uc8jah8xdcaahyirlkznk747.jpg "border=" 0 "/>

Click Install:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/3D/wKiom1Uc8JfzgzAgAAD_ E-6liwm758.jpg "border=" 0 "/>

To start the installation:

650) this.width=650; "height=" 448 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/3D/ Wkiom1uc8jfwiesyaahmaevokny095.jpg "border=" 0 "/>

When the installation is complete, click Close:

3, check the correctness of installation:

(1), check whether the service is open:

Open Server Manager:

650) this.width=650; "height=" 449 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/3D/ Wkiom1uc8jfwfwt1aadt6bl8cqs903.jpg "border=" 0 "/>

Click Configure:

650) this.width=650; "height=" 449 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/38/ Wkiol1uc8dezndunaaeu3biah2g946.jpg "border=" 0 "/>

Click Services:

650) this.width=650; "height=" 449 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/3D/ Wkiom1uc8jjth37maajmssdff4g959.jpg "border=" 0 "/>

We can see that the service is turned on.

(2), check SQL Server Administration Tools:

Open the SQL Server Administration tool:

650) this.width=650; "height=" 428 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/3D/ Wkiom1uc8jiajwjfaagi-ki3-xs011.jpg "border=" 0 "/>

Because we are logged on locally, enter "in the server name. To

650) this.width=650; "height=" 428 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/5C/3D/ Wkiom1uc8jjzlhl0aagltdyeljy799.jpg "border=" 0 "/>

Click the link:

650) this.width=650; "height=" 314 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/5C/38/wKioL1Uc8dijL1oLAADJLNki9_ A018.jpg "border=" 0 "/>

The login is successful and the administrative tools are working properly.

(3), check the SQL Server port number:

The service port for SQL Server is 1433, and here we use the Netstat/an command to check:

650) this.width=650; "height=" 418 "title=" image "style=" Border:0px;padding-top:0px;padding-right:0px;padding-left : 0px;background-image:none; "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/5C/3D/wKiom1Uc8JmibszwAAJY_ 49rzeo545.jpg "border=" 0 "/>

Here we can see that port 1433 is turned on.

ok! Our SQL Server installation is over here.

This article is from the "Technology Meng Meng" blog, please be sure to keep this source http://wuyvzhang.blog.51cto.com/9992636/1627708

Installing SQL Server R2