xenapp_xendesktop_7.6 the nine: SQL Server database server planning and deployment

Install the SQL Server database to support desktop Studio and desktop Cloud Manager data storage and access. In a simple POC test, the database can only be configured with a single machine, but when a database failure affects not only the configuration manager, but also the operation of the DDC, new user sessions will not be established (no impact on established sessions), so high availability of SQL Server must be taken into account in the production environment deployment. It is also important to note that the database must be backed up regularly to prevent data loss in the case of a database failure and to prevent the transaction log from growing. You need to plan for each DB instance name, database name, and database space size.

1.  SQL ServerDatabase Server Planning

1.1 Microsoft SQL Server versions supported by the site configuration database:

• SQL Server Express Edition, Standard Edition, and Enterprise Edition.

• SQL Server SP1 Express Edition, Standard Edition, and Enterprise Edition. By default, if a supported existing SQL server installation is not detected, SQL Server SP1 Express will be installed when the Controller is installed.

• SQL Server R2 SP2 Express Edition, Standard Edition, Enterprise Edition, and Datacenter Edition.

for information on the latest supported database versions, please refer to the Citrix website at the following link: http://support.citrix.com/article/CTX114501

1.2 The following database features are supported (except for SQL Server Express, this version supports standalone mode only):

• SQL Server Cluster instance

• SQL Server Mirroring

• SQL Server in AlwaysOn availability groups

For SQL Server high availability solutions, see the Microsoft TechNet website at the following link:

Https://technet.microsoft.com/zh-cn/library/ms190202%28v=sql.110%29.aspx

1.3 Precautions

• Although SQL Server high availability supports the above 3 approach, the failover time of SQL Server mirroring in the event of a disaster is the fastest of the three, which can be done in just a few 10 seconds. For the deployment of the production environment, in order to ensure the reliability of the database, Citrix recommends the configuration of SQL Server mirroring, in order to achieve high database availability, we deploy the database on three hosts, two database servers, to achieve the databases mirroring ; The third is the witness server.

• The SQL Server Express version (that is, the free version) database supports a maximum of 4G and does not support high availability.

1.4 SQL Server Storage planning

for the planning of SQL Server storage, refer to the Citrix official documentation, which is linked below:

http://support.citrix.com/article/CTX127939

1.5 SQL Server-related parameters used by this POC

Operating system: Windows Server R2 Standard

SQL version: SQL Server SP1 Enterprise

Installation Account: Huangjh\ctxadmin

Service Account: Huangjh\sqlservice (must ensure that the account never expires, the user can not change the password)

2.  . NET Framework 3.5the installation

2.1 Modify the SQL Server server IP address, computer name, and join the domain, and then add the account Ctxadmin and SQLService to the local Administrators group

2.2 When a SQL Server server inserts a Windows Server R2 CD (you need to specify a source path when you install. Net Framework3.5), open SQL Server Server Manager-click Add Roles and Features-- Next

2.3 Direct "next" to feature Selection page-tick ". NET Framework 3.5 Features" and "Next "

2.4 Click "Specify alternate source path"

2.5 Just now we have inserted the Windows Server R2 CD, the drive letter of the SQL Server server CD-ROM is "E", so the input path "E:\Sources\SXS\" and click "OK"

2.6 Click "Install"

2.7 After the installation is successful, click "Close" to complete the installation of the. NET Framework 3.5

3.  Configure firewall Rules

3.1 Open Windows Firewall and click "Advanced Settings"

3.2 Right-click "Inbound Rules" and "new rule"

3.3 Select "Port" and "next"

3.4 Input port number (1433,4022), Next

3.5 Select "Allow Connection", next

3.6 Next

3.7 Enter a name and click "Done"

3.8 After successfully adding the firewall rule, the following

4.  SQL Serverthe deployment

4.1 Insert the SQL Server installation disc and run SQL Server Setup, click Install-New SQL Server standalone installation or add features to an existing installation

4.2 Setup Support rule Check pass and click "OK"

4.3 Enter the product key or use the trial version, next

4.4 Tick "I accept the license terms" and the next step

4.5 uncheck "Include SQL Server product Updates" (this time can be updated according to actual needs), the next step

4.6 Support rule check: Windows Firewall we have developed 1433 and 4022 ports, warning can be ignored, next

4.7 Select "SQL Server feature Installation", Next

4.8 Select the features you want to install, modify the shared features directory, next

4.9 After the installation rule check passes, the next step

4.10 You can use the default instance or custom instance here to modify the root directory path of the instance, remember not to install on the C drive, next

4.11 Next

4.12 Modify the service account and startup type, next

4.13 Specify SQL Server administrator, next

4.14 Specifying an Analysis Services administrator, next

4.15 Next

4.16 Next

4.17 Next

4.18 Installation

4.19 after the installation is successful, click "Close" to complete the installation of SQL Server

5.  Functional Verification

5.1 Test port: Because I am using the default instance, and 4022 port is a custom instance to use, so 1433 port can be telnet, 4022 is not through

5.2 Open the command-line tool on the SQL Server server, run "netstat-a", and make sure that port 1433 is in listening state

  

5.3 Open "SQL Server Management Studio" Select the appropriate server and authentication method, click "Connect"

5.4 Successful connections are as follows:

This is the SQL Server sharing, detailed introduction of planning, deployment, functional verification and other content. Thank you for your attention and support.

This article is from the "Bright Future" blog, make sure to keep this source http://stephen1991.blog.51cto.com/8959108/1661577

xenapp_xendesktop_7.6 the nine: SQL Server database server planning and deployment