Lync Server 2013 實戰之五：後端（資料庫）伺服器安裝

標籤：sql資料庫   伺服器   blank   target   連絡人   

SQL資料庫主要用來儲存Lync 拓撲配置資訊、使用者資料（例如，存取控制清單 (ACL)、連絡人、安排的會議）、通話駐留和回應群組的資料以及存檔和監控伺服器的相關資料.

以下以SQL Server Enterprise 2012 為例

一、軟體需求

1.1、安裝SQL Server Enterprise 2012資料庫之前請先安裝.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" "400" height="285" />

1.2 單擊【指定備用源路徑】：在Windows Server 2012中安裝.NET Framwork3.5必須插入Windows 安裝光碟片並指定路徑，

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" "400" height="285" />

1.3 如在路徑欄輸入：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 點擊【安裝】

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 確認安裝完成

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 也可以直接從以下地址下載Microsoft .NET Framework 3.5完整軟體包直接安裝

或下載：Microsoft .NET Framework 3.5 Service Pack 1（完整軟體包）

http://www.microsoft.com/zh-cn/download/details.aspx?id=25150

二、安裝SQL Server 2012

2.1 點擊【安裝】—選擇【全新SQL Server 獨立安裝或向現有安裝添加功能】

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 檢查安裝程式支援規則

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 【輸入產品金鑰】

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 選擇【我接受授權條款】再【下一步】

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 要求伺服器連網並保持更新，否則報錯誤資訊

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 如果伺服器未停用防火牆則會提示以下警告資訊，但不影響SQL安裝

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 在【設定角色】中選擇【SQL Server 功能安裝】

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 勾選【資料庫引擎服務】、【Reporting Server】、【管理工具】中的基本和完整，

【Reporting Server】如果不需要安裝監控角色，也可以不選【Reporting Server】功能

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="300" />

2.9 確認安裝規則即可

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 一般情況下使用預設執行個體即可，但在實際生產環境中建議把資料庫檔案放非系統硬碟中

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 資料庫安裝的磁碟空間要求

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 實際生產環境中使用獨立域帳號作為SQL 服務帳號。安裝性不是非常嚴格的公司可以把SQL網域服務帳號設定為密碼永不到期

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 【身分識別驗證模式】建議選擇【混合模式（SQL Server 身分識別驗證和Windows 身分識別驗證）】，並指定SQL管理員（建議域帳號）

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="320" />

2.14 在【Reporting Services s配置】中選【安裝和配置】

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 錯誤報表是否要發送，一般可不選

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 確定安裝的配置規則

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 確認安裝規是後，單擊【安裝】

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 確定安裝完成後沒有錯誤

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" />

三、開放防火牆連接埠

3.1 右鍵【入站規則】—【建立規則】

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 在【要建立的規則類型】中選擇【連接埠】

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 在【此規則應用於TCP還是UDP】選擇【TCP】，在【特定本地連接埠】輸入：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 選擇【允許串連】

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 在【何進應用該規則】選擇【域】

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 輸入規則名稱，點擊完成即可

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 測試從Lync 前端Telnet 資料庫的1433連接埠

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 實戰之五：後端（資料庫）伺服器安裝