Shulou(Shulou.com)06/01 Report--

1. 2008r2 installation adjustment

1.1 system requirements

The Microsoft SQL Server version supported by the site configuration database, which initially includes the configuration logging database and the monitoring database:

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

SQL Server 2012 SP1 Express Edition, Standard Edition and Enterprise Edition. By default, if a supported existing SQL Server installation is not detected, SQL Server 2012 SP1 Express is installed when Controller is installed.

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

The following database features are supported (with the exception of SQL Server Express, this version only supports standalone mode):

SQL Server Cluster instance

SQL Server Mirror

SQL Server 2012 AlwaysOn availability group

The connection between Controller and the SQL Server database requires Windows authentication.

1.2 the License Serverg planning configuration is as follows

System: WindowsServer 2008 R2 sp1

Database: SQL Server 2008 R2 SP2

Hostname: tsdb

IP address: 10.230.10.234

Account name: kaistar.com.cn\ citrixadmin

1.3 fixed IP address and deactivate the "IPv6" communication protocol in the area connection

1.4 join the domain

1.5 turn off IEESC (server administrator è sets IEESC è off)

1.6 close user account Control Settings to do not notify

1.7 turn off firewall settings (domain network location settings,)

2. Database installation

2.1 install .net3.5

2.2 insert the SQL Server 2008 R2 CD and run the installer, click run and click "New installation or add features to an existing installation" to install SQL 2008.

2.3 Click OK

2.4 enter the serial number and click next

2.5 check to accept the terms and conditions and click next

2.6 Click to install

2.7 Click next

2.8Select SQL Server feature installation-next

2.9 install only check "SQLServer Database Engine Services", "client tool Connectivity" and "Administrative tools-basic" during installation

2.10 Click next

2.11 using the preset instance, click next

2.12 Click next

2.13 the account of SQLServer Agent and SQLServer Database Engine uses citrixadmin to start the type and select automatic. Click next.

2.14 Authentication mode selects mixed mode and the administrator joins current users

2.15 Click next

2.16 Select installation

2.17 Click close to complete the installation

2.18 insert CD to install SQLServer 2008 R2 SP1

2.19 Click next

2.20 Click Update

2.21 complete the update

2.22 insert CD to install SQL Server 2008 R2 SP2

2.23 Click next

2.24 Click Update

2.25 when the update is complete, click close

At this point, the database has been installed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.