Enterprise Cloud Desktop -12-Installing the database server -111-ctxdb01

Learning

QQ Exchange Group: 454544014

Attention:

"Enterprise Cloud Desktop" series of blog is the "Enterprise Cloud desktop planning, deployment and operation of the Practice Guide," the basic part, because the book contains a lot of content, very comprehensive, so the basic part will be in the form of blog post to the reader, will be quoted in the book.

The Enterprise Cloud Desktop planning, deployment and Operations Practice guide will be based on a Social Security Center cloud desktop, using the VMware Workstation Pro 12.5.2 to simulate on 1 physical machines. Readers follow the steps in the book to do it, and it can be achieved.

1. Basic Settings 1.1. Server Basic Configuration

Number	Project	Value	Note
1	Role	Database server
2	Software	cn_sql_server_2012_enterprise_edition_with_sp1_x64_dvd_1234495
3	Computer name	111-ctxdb01.i-zhishi.com
4	Ip	10.1.1.111
5	Operating system	Windows Server R2
6	Cpu	Inter (R) Xeon (r) CPU e5-2609 v3 @1.90ghz (2 CPUs)
7	Memory	4GB
8	Hard disk	500GB

1.2. Virtual machines

650) this.width=650; "height=" "title=" clip_image002 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image002 "src=" http://s3.51cto.com/wyfs02/ M01/94/0d/wkiol1klq-zbzjs8aac48-kpqtg290.jpg "border=" 0 "/>

1.3. Computer name-ip

1) Computer name

650) this.width=650; "height=" 454 "title=" clip_image004 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image004 "src=" http://s3.51cto.com/wyfs02/ M02/94/0d/wkiol1klq-3hkugaaadmkfsv0k4104.jpg "border=" 0 "/>

2) IP

650) this.width=650; "height=" 484 "title=" clip_image005 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image005 "src=" http://s3.51cto.com/wyfs02/ M00/94/0e/wkiom1klq-6rebifaad3eh9wz5y162.png "border=" 0 "/>

3) Computer name-ip

650) this.width=650; "height=" "title=" clip_image007 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image007 "src=" http://s3.51cto.com/wyfs02/ M00/94/0d/wkiol1klq-6tl0htaablqmn4dc8718.jpg "border=" 0 "/>

1.4. Preparation-Installation-position-for Db_ctx

D:

Db

Db_ctx

650) this.width=650; "height=" 295 "title=" clip_image009 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image009 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klq-_ait2laab5np0r3hi622.jpg "border=" 0 "/>

2. Install-sql Server with SP1

Reference:

To install SQL Server 2012 (Setup) by using the Setup Wizard

Http://msdn.microsoft.com/zh-cn/library/ms143219.aspx

ISO:cn_sql_server_2012_enterprise_edition_with_sp1_x64_dvd_1234495.iso

1) Insert the SQL Server installation media, and then double-click Setup.exe in the root folder. To install from a network share, locate the root folder in the share, and then double-click Setup.exe.

650) this.width=650; "height=" 338 "title=" clip_image011 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image011 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klq_ccw8szaacw10o94gw522.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image013 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image013 "src=" http://s3.51cto.com/wyfs02/ M02/94/0e/wkiol1klq_hqkts5aaeuur6cdbw625.jpg "border=" 0 "/>

2) The Installation Wizard will run the SQL Server installation Center. To create a new SQL Server installation, click Install in the left navigation area, and then click New SQL Server standalone installation or add features to an existing installation.

650) this.width=650; "height=" 484 "title=" clip_image015 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image015 "src=" http://s3.51cto.com/wyfs02/ M01/94/0f/wkiom1klq_kgckjoaadr9tnubhs238.jpg "border=" 0 "/>

3) The System Configuration Checker will run the discovery operation on your computer. To continue, click OK. You can view the details on the screen by clicking Show Details, or view it as an HTML report by clicking View Detailed report.

650) this.width=650; "height=" 484 "title=" clip_image017 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image017 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klq_oixzpwaac62sffhww620.jpg "border=" 0 "/>

4) on the Product Key page, select an option to indicate whether you are installing a free version of SQL Server or installing a production version of a product that has a PID key. For more information, see Versions and components of SQL Server 2012.

To continue, click Next.

650) this.width=650; "height=" 484 "title=" clip_image019 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image019 "src=" http://s3.51cto.com/wyfs02/ M02/94/0f/wkiom1klq_th2f9paadu9updhqy135.jpg "border=" 0 "/>

5) Review the license agreement on the License Terms page, and if you agree, select the I accept the License Terms check box, and then click Next. To help improve SQL Server, you can also enable feature usage options and send reports to Microsoft.

650) this.width=650; "height=" 484 "title=" clip_image021 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image021 "src=" http://s3.51cto.com/wyfs02/ M00/94/0f/wkiom1klq_bwuwp8aaeqsa4bs3s993.jpg "border=" 0 "/>

6) on the Product Updates page, the most recently available SQL Server product updates are displayed. If you do not want to include updates, uncheck the Include SQL Server product updates check box. If no product updates are found, SQL Server Setup does not display the page and automatically advances to the Install Setup Files page.

650) this.width=650; "height=" 484 "title=" clip_image023 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image023 "src=" http://s3.51cto.com/wyfs02/ M00/94/0e/wkiol1klq_eymkouaadzfzm4giq041.jpg "border=" 0 "/>

7) on the Install Setup Files page, the Setup program provides the progress of downloading, extracting, and installing these setup files. If an update is found for the SQL Server Setup program and the update is specified to be included, the update will also be installed.

650) this.width=650; "height=" 484 "title=" clip_image025 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image025 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klq_isqs7laadak-xw78g256.jpg "border=" 0 "/>

8) The System Configuration Checker verifies the system state of the computer before the installation continues.

650) this.width=650; "height=" 484 "title=" clip_image027 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image027 "src=" http://s3.51cto.com/wyfs02/ M02/94/0f/wkiom1klq_mqwrkaaadq0p2ffk8073.jpg "border=" 0 "/>

9) on the Set Roles page, select SQL Server feature Installation, and then click Next to continue to the feature Selection page.

650) this.width=650; "height=" 484 "title=" clip_image029 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image029 "src=" http://s3.51cto.com/wyfs02/ M02/94/0e/wkiol1klq_rsysz8aad0dne8jbu006.jpg "border=" 0 "/>

10) on the Feature Selection page, select the components to install. After you select a feature name, a description of each component group is displayed in the feature Description pane. You can select any of the check boxes.

650) this.width=650; "height=" 484 "title=" clip_image031 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image031 "src=" http://s3.51cto.com/wyfs02/ M00/94/0e/wkiol1klq_vz_qhpaaeixw08h84781.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image033 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image033 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klq_yjfhu4aafme55fgf4984.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image035 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image035 "src=" http://s3.51cto.com/wyfs02/ M02/94/0e/wkiol1klq_7jumwgaaffejwzy2e558.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image037 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image037 "src=" http://s3.51cto.com/wyfs02/ M00/94/0f/wkiom1klq__tcj3aaae-rrbirig628.jpg "border=" 0 "/>

11) on the Installation Rules page, the Setup program verifies the system state of the computer before the installation continues.

650) this.width=650; "height=" 484 "title=" clip_image039 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image039 "src=" http://s3.51cto.com/wyfs02/ M01/94/0f/wkiom1klracycbcvaadv1a1as1w065.jpg "border=" 0 "/>

12) On the instance configuration page, specify whether to install a default instance or a named instance. For more information, see instance Configuration. Click "Next" to continue.

650) this.width=650; "height=" 484 "title=" clip_image041 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image041 "src=" http://s3.51cto.com/wyfs02/ M02/94/0f/wkiom1klrahtldrraaelu96zxm4457.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image043 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image043 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klrakbchi0aaermyktoys424.jpg "border=" 0 "/>

13) The Disk Space Requirements page calculates the disk space required for the specified feature, and then compares the required space with the available disk space.

650) this.width=650; "height=" 484 "title=" clip_image045 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image045 "src=" http://s3.51cto.com/wyfs02/ M00/94/0f/wkiom1klrapidxsaaadjngcc4gk848.jpg "border=" 0 "/>

14) Use the server Configuration-Service Account page to specify the logon account for the SQL Server service. The actual services configured on this page depend on the features you choose to install. When you have finished specifying the logon information for the SQL Server service, click Next.

650) this.width=650; "height=" 484 "title=" clip_image047 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image047 "src=" http://s3.51cto.com/wyfs02/ M02/94/0e/wkiol1klratdcusbaaey_fgokus586.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image049 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image049 "src=" http://s3.51cto.com/wyfs02/ M01/94/0f/wkiom1klraxdbt6baaexjfguj9y669.jpg "border=" 0 "/>

15) Use the server configuration-collation page to specify a non-default collation for the database engine and analysis Services.

650) this.width=650; "height=" 484 "title=" clip_image051 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image051 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klraazbalvaaerlltrhls386.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image052 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image052 "src=" http://s3.51cto.com/wyfs02/ M01/94/0f/wkiom1klrajifksoaagumgk3ufq055.png "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image053 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image053 "src=" http://s3.51cto.com/wyfs02/ M02/94/0f/wkiom1klraqykfu2aagevnikymi597.png "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image055 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image055 "src=" http://s3.51cto.com/wyfs02/ M00/94/0f/wkiom1klravttsgzaaerawmnk7k940.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image057 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image057 "src=" http://s3.51cto.com/wyfs02/ M01/94/0f/wkiom1klraya1rx0aaezvqtuydu318.jpg "border=" 0 "/>

16) Use the Database engine configuration-Account Settings page to specify the following:

When you are finished editing the list, click OK. Verify the list of administrators in the Configuration dialog box. When you are finished with this list, click Next.

17) Use the database engine configuration-Data catalog page to specify a nondefault installation directory. To install to the default directory, click Next.

Important Note Important Notice

If you specify a non-default installation directory, make sure that the installation folder is unique for this instance of SQL Server. Any directory in this dialog box should not be shared with the directory of other instances of SQL Server.

18) Use the Database engine configuration-FILESTREAM page to enable FILESTREAM for the SQL Server instance.

650) this.width=650; "height=" 484 "title=" clip_image059 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image059 "src=" http://s3.51cto.com/wyfs02/ M00/94/0e/wkiol1klra2yeeghaaeeqrbirms687.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image061 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image061 "src=" http://s3.51cto.com/wyfs02/ M02/94/0f/wkiom1klra7r-gp4aaett19tc-8628.jpg "border=" 0 "/>

19) Use the Analysis Services Configuration – Account Settings page to specify the server mode and the user or account that will have Analysis Services administrator rights. The server mode determines which memory and storage subsystems are used for the server. Different solution types run in different server modes. If you plan to run the cube database on the server, select the default option multidimensional and data Mining server mode. For administrator rights, you must specify at least one system administrator for analysis Services. To add an account that is currently running SQL Server Setup, click the Add Current User button. To add or remove accounts from the list of system administrators, click Add or Remove, and then edit the list of users, groups, or computers that will have administrator privileges for analysis Services. When you are finished editing the list, click OK. Verify the list of administrators in the Configuration dialog box. When you are finished with this list, click Next.

20) Use the analysis Services configuration-Data catalog page to specify a nondefault installation directory. To install to the default directory, click Next.

650) this.width=650; "height=" 484 "title=" clip_image063 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image063 "src=" http://s3.51cto.com/wyfs02/ M02/94/0e/wkiol1klra-qpb4faad6vfgg9o0336.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image065 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image065 "src=" http://s3.51cto.com/wyfs02/ M00/94/0f/wkiom1klrbcy-xxgaaebhy2l-_e428.jpg "border=" 0 "/>

21) Use the Reporting Services Configuration page to specify the type of Reporting services installation you want to create. When you have selected the options, click Next to continue.

650) this.width=650; "height=" 484 "title=" clip_image067 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image067 "src=" http://s3.51cto.com/wyfs02/ M02/94/0e/wkiol1klrbgsitlvaaeh_30vzoq652.jpg "border=" 0 "/>

22) on the Error Reporting page, specify the information that you want to send to Microsoft to help improve SQL Server. By default, the option to use for error reporting is enabled.

650) this.width=650; "height=" 484 "title=" clip_image069 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image069 "src=" http://s3.51cto.com/wyfs02/ M00/94/0e/wkiol1klrbkratuoaaefabxr2ac330.jpg "border=" 0 "/>

23) The System Configuration Checker will run multiple sets of rules to verify the configuration of the computer with the SQL Server features you specified.

650) this.width=650; "height=" 484 "title=" clip_image071 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image071 "src=" http://s3.51cto.com/wyfs02/ M01/94/0f/wkiom1klrboznf4kaadybapvjbu354.jpg "border=" 0 "/>

24) The Ready to Install page displays a tree view of the installation options specified during installation. On this page, the Setup program indicates whether the product update feature is enabled or disabled, and the final updated version.

To continue, click Install. SQL Server Setup installs the prerequisites for the selected feature first, and then installs the selected features.

650) this.width=650; "height=" 484 "title=" clip_image073 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image073 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klrbxc5_tjaaepspxbzhc423.jpg "border=" 0 "/>

25) During the installation process, the installation Progress page provides the appropriate status so that you can monitor the installation progress during the installation process.

650) this.width=650; "height=" 484 "title=" clip_image075 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image075 "src=" http://s3.51cto.com/wyfs02/ M02/94/0f/wkiom1klrbayagruaacwrpbiizk024.jpg "border=" 0 "/>

26) When the installation is complete, the completion page provides links to the installation summary log files and other important notes. To complete the SQL Server installation process, click Close.

650) this.width=650; "height=" 484 "title=" clip_image077 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image077 "src=" http://s3.51cto.com/wyfs02/ M02/94/0f/wkiom1klrbfsaftraafamm5rcgs398.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image079 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image079 "src=" http://s3.51cto.com/wyfs02/ M00/94/0e/wkiol1klrbmsijccaadrtdzs0mw503.jpg "border=" 0 "/>

Installation is complete.

3. Verifying the installation results

650) this.width=650; "height=" 388 "title=" clip_image081 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image081 "src=" http://s3.51cto.com/wyfs02/ M00/94/0e/wkiol1klrbqiop8oaafclrm9xei324.jpg "border=" 0 "/>

111-ctxdb01\db_ctx

650) this.width=650; "height=" 370 "title=" clip_image082 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image082 "src=" http://s3.51cto.com/wyfs02/ M01/94/0f/wkiom1klrbvqcnynaado4u4yhcc489.png "border=" 0 "/>

650) this.width=650; "height=" 406 "title=" clip_image084 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image084 "src=" http://s3.51cto.com/wyfs02/ M02/94/0e/wkiol1klrbvig9jkaac60ukl0py516.jpg "border=" 0 "/>

650) this.width=650; "height=" 380 "title=" clip_image086 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image086 "src=" http://s3.51cto.com/wyfs02/ M00/94/0f/wkiom1klrbzqtbevaae8ciwvjwe849.jpg "border=" 0 "/>

650) this.width=650; "height=" 314 "title=" clip_image087 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image087 "src=" http://s3.51cto.com/wyfs02/ M02/94/0e/wkiol1klrb3zt1giaaekkbq_k90231.png "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image089 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image089 "src=" http://s3.51cto.com/wyfs02/ M00/94/0f/wkiom1klrb6hm0rbaadbe9d9hwo015.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image091 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image091 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klrb_st5ofaadxbxblqoc792.jpg "border=" 0 "/>

650) this.width=650; "height=" 196 "title=" clip_image093 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image093 "src=" http://s3.51cto.com/wyfs02/ M00/94/0e/wkiol1klrccanyvhaab27s7-ln8988.jpg "border=" 0 "/>

650) this.width=650; "height=" 484 "title=" clip_image095 "style=" margin:0px;border:0px;padding-top:0px; Padding-right:0px;padding-left:0px;background-image:none, "alt=" clip_image095 "src=" http://s3.51cto.com/wyfs02/ M01/94/0e/wkiol1klrcghbwahaadkgw-uwae806.jpg "border=" 0 "/>

650) this.width=650; "height=" 228 "title=" clip_image097 "style=" border:0px;padding-top:0px;padding-right:0px; Padding-left:0px;background-image:none, "alt=" clip_image097 "src=" http://s3.51cto.com/wyfs02/M02/94/0F/ Wkiom1klrcltbfzoaab5msl1zuo243.jpg "border=" 0 "/>

This article has been completed.

This article is from the "Lifelong Learning" blog, please be sure to keep this source http://dynamic.blog.51cto.com/711418/1922228

Enterprise Cloud Desktop -12-Installing the database server -111-ctxdb01