Installing the SQL Server R2 database

The version of SQL Server database has Enterprise Edition, Standard Edition, Web Edition, Development Board.

Enterprise Edition: can only be installed in the server operating system

Database classification:

Hierarchy: The organizational structure for general enterprises

Mesh: Typically used to represent the complexity between objects

Relational: A relationship is a two-dimensional table with rows and columns.

Install the. NET Fram 3.5.1 feature First in the SQL Server database installation

Server Manager--add features

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E9/ Wkiom1vuubwrb9tmaafpvdopjn8254.jpg "" 549 "height=" 406 "/>

Mount the image of SQL Server

Open Explorer--click Drive--right--install from media or allow program

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/6D/E9/ Wkiom1vuubxicwrzaafsbv84mbw511.jpg "" 551 "height=" 373 "/>

Click Install--Select the first new installation or add features to an existing installation

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/6D/E9/ Wkiom1vuubbsvrakaafadfjfgfo621.jpg "" 553 "height=" 397 "/>

Are you sure

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E5/ Wkiol1vuu1gcq170aadps-age8o208.jpg "" 561 "height=" 392 "/>

Accept

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/6D/E9/ Wkiom1vuubeqxea9aagpiyabfsi527.jpg "" 572 "height=" 385 "/>

Installation

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/6D/E9/wKiom1VuubqjpZO-AAD-KRZe_ Ho477.jpg "" 571 "height=" 397 "/>

Next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/6D/E5/ Wkiol1vuu1bic5pzaaib2ts9zxe114.jpg "" 589 "height=" 411 "/>

SQL Server feature installation, next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E5/ Wkiol1vuu12issxiaaf0tl-dppy627.jpg "" 599 "height=" 416 "/>

Can select all, next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/6D/E5/ Wkiol1vuu12ygxntaahnos84t3g813.jpg "" 607 "height=" 421 "/>

Next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/6D/E5/ Wkiol1vuu16cxezvaafdoxtaxju780.jpg "" 616 "height=" 427 "/>

Default instance, next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E5/ Wkiol1vuu17dainyaahe3sikkbm737.jpg "" 626 "height=" 437 "/>

Next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/6D/E5/wKioL1Vuu1_ Q2lp2aafyv5y0cts487.jpg "" 632 "height=" 439 "/>

Next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/6D/E5/ Wkiol1vuu2pq7tjjaaisbmgtsaq728.jpg "644" height= "/>"

Use the same user for all SQL Server services

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E5/ Wkiol1vuu2prosoeaad4x52ta7i788.jpg "" 641 "height="/>

Mixed mode: Mixed mode includes Windows authentication

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/6D/E5/ Wkiol1vuu2ttaevoaaibxbioezi625.jpg "" 644 "height=" 452 "/>

Next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/6D/E5/wKioL1Vuu2Th7VOQAAHGRrEX_ Wk660.jpg "" 654 "height=" 454 "/>

Next

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E5/ Wkiol1vuu2wga74baafwgpdr96g066.jpg "" 664 "height=" 463 "/>

Installation

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/6D/E9/ Wkiom1vuuc2zd7xmaahpncsiqsc181.jpg "" 670 "height=" 465 "/>

Installation Complete

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/6D/E9/ Wkiom1vuuc7sdt-baahyqvcmdhc117.jpg "" 675 "height=" 469 "/>

Check installation correctness:

Check that the service is in the startup state

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E9/ Wkiom1vuuc6bpktkaadutkvp6-i232.jpg "" 481 "height=" 290 "/>

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/6D/E5/ Wkiol1vuu2rxz0mpaahccbbhfny866.jpg "" 707 "height="/>

Check SQL Server Administration Tools

. Indicates the native login

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E5/ Wkiol1vuu2ucf4o8aahbtxqnjfw715.jpg "" 696 "height=" 465 "/>

Post-Login interface

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/6D/E9/ Wkiom1vuuddje51naaej3rygg04690.jpg "" 703 "height=" 394 "/>

Check the SQL Server port number (1433)

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/6D/E9/ Wkiom1vuudhcbgwsaaecqsn7kje250.jpg "" 690 "height=" 447 "/>

Installing the SQL Server R2 database