Citrix environment, SQL Server R2 Mirroring Deployment (i)

A. Introduction to the basic Environment

1. operating system version

server operating system: windowsserver R2 with SP1 datecenter

SQL Server version: SQL Server R2 with SP1 enterprise_core

2. Server Roles

CTXDB01 IP : 192.168.50.181 principal server

CTXDB02 IP : 192.168.50.182 mirror server

Ctxdbwit IP : 192.168.50.190 Witness Server

3.AD OUs Prepare

Database administrator account: DBAdmin, to join the local Administrators group for SQL Server.

Database Mirroring service Account: SQLACC

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/83/D2/wKiom1d9rteTu0SNAAFcDa1p-fE290.png-wh_500x0-wm_3 -wmp_4-s_1933721509.png "title=" 1.png "alt=" Wkiom1d9rtetu0snaafcda1p-fe290.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/83/D2/wKiom1d9rvHQUVE2AAEqF8_wlH8606.png-wh_500x0-wm_3 -wmp_4-s_121435091.png "style=" Float:none; "title=" 2.png "alt=" Wkiom1d9rvhquve2aaeqf8_wlh8606.png-wh_50 "/>

two. SQL ServerPre-Installation Preparation2.1install the. NET Framework 3.5.1 Feature

instrument Panel Click " add roles and features "

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/83/D1/wKioL1d9rvOBVhARAAN0IONOYbg320.png-wh_500x0-wm_3 -wmp_4-s_790477790.png "title=" 3.png "style=" Float:none; alt= "Wkiol1d9rvobvharaan0ionoybg320.png-wh_50"/>

Default Next

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/83/D1/wKioL1d9rvPgx_DSAAFhsIHfUHE775.png-wh_500x0-wm_3 -wmp_4-s_4001109905.png "title=" 4.png "style=" Float:none; alt= "Wkiol1d9rvpgx_dsaafhsihfuhe775.png-wh_50"/>

Feature page Tick the ". NET Framework 3.5.1" feature, Next

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/83/D2/wKiom1d9rvSzO497AAInKhQz6mw260.png-wh_500x0-wm_3 -wmp_4-s_2353502633.png "title=" 5.png "style=" Float:none; alt= "Wkiom1d9rvszo497aainkhqz6mw260.png-wh_50"/>

windowsserver R2 The default path is missing the source file, select the appropriate path for the system iOS file from the specified alternate path, and then install it.

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/83/D1/wKioL1d9rvTwHk26AAHHKfJ3JbU846.png-wh_500x0-wm_3 -wmp_4-s_2544101174.png "title=" 6.png "style=" Float:none; alt= "Wkiol1d9rvtwhk26aahhkfj3jbu846.png-wh_50"/>

Specify the system iOS file Mount path D:\Sources\SxS, click OK

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/83/D2/wKiom1d9rvWDLGKRAALSNA3qbc0211.png-wh_500x0-wm_3 -wmp_4-s_805102537.png "title=" 7.png "style=" Float:none; alt= "Wkiom1d9rvwdlgkraalsna3qbc0211.png-wh_50"/>

Tick "Automatically restart target server if required" and select "Yes"

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/83/D2/wKiom1d9rvaAB2loAAIdopil5PM849.png-wh_500x0-wm_3 -wmp_4-s_3951055814.png "title=" 8.png "style=" Float:none; alt= "Wkiom1d9rvaab2loaaidopil5pm849.png-wh_50"/>

Click "Install"

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/83/D1/wKioL1d9rveAufKfAAFgmdaqs_U176.png-wh_500x0-wm_3 -wmp_4-s_38012611.png "title=" 9.png "style=" Float:none; alt= "Wkiol1d9rveaufkfaafgmdaqs_u176.png-wh_50"/>

Installation is successful, click Close. The next step is to install SQL Server.

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/83/D1/wKioL1d9rvfAf3knAAFZWUMBi6g531.png-wh_500x0-wm_3 -wmp_4-s_1167678206.png "title=" 10.png "style=" Float:none; alt= "Wkiol1d9rvfaf3knaafzwumbi6g531.png-wh_50"/>

2.2join dbadmin to the SQL Server local Administrators group

Open Computer Management, select Local Users and Groups

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/83/D2/wKiom1d9rvjjM7PfAAF6j85NIc0193.png-wh_500x0-wm_3 -wmp_4-s_1840541873.png "title=" 11.png "style=" Float:none; alt= "Wkiom1d9rvjjm7pfaaf6j85nic0193.png-wh_50"/>

Right-Select Administrators, select Properties, click Add

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/83/D1/wKioL1d9rvjwFYSiAAEg1N_bZgk668.png-wh_500x0-wm_3 -wmp_4-s_124865644.png "title=" 12.png "style=" Float:none; alt= "Wkiol1d9rvjwfysiaaeg1n_bzgk668.png-wh_50"/>

Enter Dbadmin, check the name, determine

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/83/D2/wKiom1d9rvnxYk1KAAEtg1Y2BG8988.png-wh_500x0-wm_3 -wmp_4-s_1095968798.png "title=" 13.png "style=" Float:none; alt= "Wkiom1d9rvnxyk1kaaetg1y2bg8988.png-wh_50"/>

Are you sure

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/83/D2/wKiom1d9rvnzhVW7AAEqTVOUHiQ206.png-wh_500x0-wm_3 -wmp_4-s_869782888.png "title=" 14.png "style=" Float:none; alt= "Wkiom1d9rvnzhvw7aaeqtvouhiq206.png-wh_50"/>

This article is from the "Qing Cream Drunken Maple" blog, please be sure to keep this source http://ctianlong.blog.51cto.com/1458700/1811724

Citrix environment, SQL Server R2 Mirroring Deployment (i)