SQL databases are primarily used to store Lync topology configuration information, user data (for example, access control lists (ACLs), contacts, scheduled meetings), data for Call park and response groups, and data about archiving and monitoring servers.
The following is an example of SQL Server Enterprise 2012
First, software requirements
1.1. Before installing the SQL Server Enterprise 2012 database, install the. NET Framework 3.5
650) this.width=650; "title=" clip_image002 "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=" clip_image002 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026172qxxp.jpg "" "height=" 285 "/>
1.2 Click Specify alternate source path: Installing. NET Framwork3.5 in Windows Server 2012 must insert the Windows installation disc and specify the path.
650) this.width=650; "title=" clip_image004 "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=" clip_image004 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026172tewt.jpg "" "height=" 285 "/>
1.3 Enter as in the path bar:E\source\sxs
650) this.width=650; "title=" clip_image006 "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=" clip_image006 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026173myei.jpg "" 383 "height=" 268 "/>
1.4 Click "Install"
650) this.width=650; "title=" clip_image008 "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=" clip_image008 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026173oxxx.jpg "" 386 "height=" 275 "/>
1.5 Confirm the installation is complete
650) this.width=650; "title=" clip_image010 "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=" clip_image010 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026174depy.jpg "" 388 "height=" 276 "/>
1.6 You can also download the Microsoft. NET Framework 3.5 Full Package direct installation directly from the following address
or download:Microsoft. NET Framework 3.5 Service Pack 1(full package)
http://www.microsoft.com/zh-cn/download/details.aspx?id=25150
Ii. Installing SQL Server 2012
2.1 Click "Install"-select "New SQL Server Standalone installation or add features to an existing installation"
650) this.width=650; "title=" clip_image012 "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=" clip_image012 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026174smsb.jpg "" 409 "height=" 308 "/>
2.2 Checking the Setup support rules
650) this.width=650; "title=" clip_image014 "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=" clip_image014 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 14110261744ry8.jpg "" 411 "height=" 309 "/>
2.3 "Enter Product Key"
650) this.width=650; "title=" clip_image016 "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=" clip_image016 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026175ynfi.jpg "" 415 "height=" 313 "/>
2.4 Select "I accept the license terms" and "next"
650) this.width=650; "title=" clip_image018 "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=" clip_image018 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 14110261753kgt.jpg "" 415 "height=" 311 "/>
2.5 require the server to be networked and keep up to date, otherwise report an error message
650) this.width=650; "title=" clip_image020 "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=" clip_image020 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026176wv1k.jpg "" 417 "height=" 314 "/>
2.6 If the server does not deactivate the firewall, the following warning message is prompted, but does not affect the SQL installation
650) this.width=650; "title=" clip_image022 "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=" clip_image022 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 14110261772hob.jpg "" 416 "height=" 312 "/>
2.7 Select "SQL Server Feature Installation" in "Setting role"
650) this.width=650; "title=" clip_image024 "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=" clip_image024 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026177nivr.jpg "" 415 "height=" 312 "/>
2.8 Tick "Database Engine services", "Reporting Server", "Administrative Tools" in the basic and complete,
"Reporting Server" If you do not need to install a monitoring role, you can also uncheck the "Reporting Server" feature
650) this.width=650; "title=" clip_image026 "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=" clip_image026 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026178mal4.jpg "" 417 "height="/>
2.9 Confirm the installation rules
650) this.width=650; "title=" clip_image028 "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=" clip_image028 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026178lpps.jpg "" 428 "height=" 308 "/>
2.10 The default instance is used in general, but it is recommended to put the database file in a non-system disk in the actual production environment
650) this.width=650; "title=" clip_image030 "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=" clip_image030 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026179hhuw.jpg "" 429 "height=" 307 "/>
2.11 Disk space requirements for database installation
650) this.width=650; "title=" clip_image032 "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=" clip_image032 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026179dz5b.jpg "" 416 "height=" 298 "/>
2.12 The actual production environment uses a separate domain account as the SQL service account. The installation is not very strict company can set the SQL Domain service account number as password never expires
650) this.width=650; "title=" clip_image034 "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=" clip_image034 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026179cms1.jpg "" 420 "height=" 317 "/>
2.13 "Authentication Mode" recommends selecting "Mixed Mode (SQL Server authentication and Windows Authentication)" and specifying the SQL administrator (recommended domain account)
650) this.width=650; "title=" clip_image036 "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=" clip_image036 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026180jdjh.jpg "" 428 "height=" "the"/>
2.14 Select "Install and configure" in "Reporting Services s Configuration"
650) this.width=650; "title=" clip_image038 "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=" clip_image038 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026181dvyb.jpg "" 427 "height=" 321 "/>
2.15 Error Reporting whether to send, generally not optional
650) this.width=650; "title=" clip_image040 "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=" clip_image040 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026181ljpf.jpg "" 424 "height=" 318 "/>
2.16 Determining the configuration rules for the installation
650) this.width=650; "title=" clip_image042 "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=" clip_image042 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 14110261820ou9.jpg "" 425 "height=" 319 "/>
2.17 after confirming the installation rules, click "Install"
650) this.width=650; "title=" clip_image044 "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=" clip_image044 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026182bfg4.jpg "" 422 "height=" 318 "/>
2.18 Make sure there are no errors after installation is complete
650) this.width=650; "title=" clip_image046 "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=" clip_image046 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026183fmd4.jpg "" 424 "height=" 318 "/>
Third, open firewall port
3.1 Right-click "Inbound Rules"-"new rule"
650) this.width=650; "title=" clip_image048 "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=" clip_image048 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026184f4qs.jpg "" 436 "height=" 370 "/>
3.2 Select port in the rule type to create
650) this.width=650; "title=" clip_image050 "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=" clip_image050 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026184gfpj.jpg "" 442 "height=" 331 "/>
3.3 In "This rule applies to TCP or UDP" select "TCP", in "specific local port" input: 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://img1.51cto.com/attachment/201409/18/468619_ 1411026185nzwe.png "" 442 "height=" 331 "/>
3.4 Select "Allow connection"
650) this.width=650; "title=" clip_image052 "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=" clip_image052 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 14110261852z0f.jpg "" 437 "height=" 329 "/>
3.5 in the "Where to apply the rule" select "Domain"
650) this.width=650; "title=" clip_image054 "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=" clip_image054 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026186kspo.jpg "" 435 "height=" 329 "/>
3.6 Enter the rule name and click Done
650) this.width=650; "title=" clip_image056 "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=" clip_image056 "src=" http://img1.51cto.com/attachment/201409/18/468619_ 1411026186wmld.jpg "" 441 "height=" 331 "/>
3.7 Testing 1433 ports from the Lync front-end Telnet database
650) this.width=650; "title=" BB4 ' M__d8[ps1li5y3_tlh2 "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=" BB4 ' M__d8[ps1li5y3_tlh2 "src=" http://img1.51cto.com/attachment/201409/18/ 468619_1411026187ee5b.png "" 448 "height=" 294 "/>
Lync Server 2013 Combat Five: Back-end (database) Server installation