為 SharePoint Server 使用第三方提供者安裝及設定 RBSInstall and configure RBS with a 3rd party provider for SharePoint Server

摘要:了解如何安裝和設定使用 SharePoint Server 2016 和 SharePoint 2013 之協力廠商 RBS 提供者的遠端 BLOB 儲存 (RBS)。Summary: Learn how to install and configure Remote BLOB Storage (RBS) that uses a third-party RBS Provider for SharePoint Server 2016 and SharePoint 2013.

SharePoint Server 使用 RBS 功能,將 BLOB 儲存在內容資料庫的外面。如需 RBS 的詳細資訊,請參閱<SharePoint Server 中的 RBS 概觀>。SharePoint Server uses the RBS feature to store BLOBs outside the content database. For more information about RBS, see Overview of RBS in SharePoint Server.

重要

這個解決方案使用協力廠商提供者。繼續之前,請務必閱讀提供者製造商的指示說明。如果您想要安裝和設定使用 FILESTREAM 提供者的 RBS,請使用<在 SharePoint Server 伺服器陣列中使用 FILESTREAM 來安裝和設定 RBS>中的程序。This solution uses a third-part provider. Before continuing, make sure that you read the instructions from the manufacturer of the provider. If you want to install and configure RBS using the FILESTREAM provider, use the procedure in Install and configure RBS with FILESTREAM in a SharePoint Server farm.

使用協力廠商提供者時,請不要直接存取 BLOB。請永遠使用 SharePoint Server 存取這些 BLOB。Do not directly access BLOBs when you are using third-party providers. Always access these BLOBs by using SharePoint Server.

開始之前Before you begin

您只需要為伺服器陣列安裝和設定特定協力廠商提供者的 RBS 一次。不過,如果您想要啟用使用 FILESTREAM 提供者的 RBS,請使用<在 SharePoint Server 伺服器陣列中使用 FILESTREAM 來安裝和設定 RBS>中的程序。You only have to install and configure RBS with the specific third-part provider one time for the farm. However, if you want to enable RBS using the FILESTREAM provider, use the procedure in Install and configure RBS with FILESTREAM in a SharePoint Server farm.

開始這項作業之前,請參閱下列有關先決條件的資訊:Before you begin this operation, review the following information about prerequisites:

  • 佈建 RBS 儲存的使用者帳戶必須是為其設定 RBS 的每個資料夾中 db_owner 固定資料庫角色的成員。The user account provisioning RBS stores must be a member of the db_owner fixed database role on each database that you are configuring RBS for.

  • 安裝用戶端文件庫的使用者帳戶必須是要安裝文件庫之所有電腦上 Administrators 群組的成員。The user account installing the client library must be a member of the Administrators group on all of the computers where you are installing the library.

  • 啟用 RBS 的使用者帳戶時必須具有執行 PowerShell 的足夠權限。The user account enabling RBS must have sufficient permissions to run PowerShell.

在每個前端或應用程式伺服器上安裝 RBS 用戶端程式庫Install the RBS client library on each front-end or application server

您必須在 SharePoint 伺服器陣列中的所有網頁伺服器上,安裝 RBS 用戶端文件庫。每個網頁伺服器只會安裝 RBS 用戶端文件庫一次,但會針對每個關聯的內容資料庫個別設定 RBS。用戶端文件庫包含連結至使用者應用程式的用戶端 DLL,也包含一組安裝在 SQL Server 上的預存程序。You must install RBS client library on all Web servers in the SharePoint farm. The RBS client library is installed only one time per Web server, but RBS is configured separately for each associated content database. The client library consists of a client-side DLL that is linked into a user application, and also a set of stored procedures to be installed on SQL Server.

警告

請勿透過執行 RBS_x64.msi 檔案並啟動安裝 SQL 遠端 BLOB 儲存精靈的方式安裝 RBS。此精靈會設定一些不建議在 SharePoint Server 中使用的預設值。Do not install RBS by running the RBS_x64.msi file and starting the Install SQL Remote BLOB Storage wizard. The wizard sets certain default values that are not recommended for SharePoint Server.

在第一個前端或應用程式伺服器上安裝 RBS 用戶端程式庫To install the RBS client library on the on the first front-end or application server

  1. 確認執行這些步驟的使用者帳戶是安裝程式庫所在之電腦的系統管理員群組成員。Confirm that the user account performing these steps is a member of the Administrators group on the computer where you are installing the library.

  2. 在任何前端或應用程式伺服器上,針對 SharePoint Server 2016,下載 Microsoft SQL Server 2014 Feature Pack。若要建立 X64 RBS.msi 檔案的安裝資料夾,請執行自我解壓縮下載套件。On any front-end or application server, for SharePoint Server 2016, download the Microsoft SQL Server 2014 Feature Pack. Run the self-extracting download package to create an installation folder for the X64 RBS.msi file.

    針對 SharePoint 2013,下載 RBS_amd64.msi 檔案For SharePoint 2013, download the RBS_amd64.msi file.

  3. 複製下列命令,並將其貼至命令提示字元視窗。將 WSS_Content 改成資料庫名稱,然後將 DBInstanceName 改成 SQL Server 執行個體名稱。您只能使用特定資料庫名稱和 SQL Server 執行個體名稱執行此命令一次。作業約一分鐘內完成。Copy and paste the following command into the Command Prompt window. Replace WSS_Content with the database name, and replace DBInstanceName with the SQL Server instance name. You should run this command by using the specific database name and SQL Server instance name only one time. The operation should finish within approximately one minute.

    msiexec /qn /lvx* rbs_install_log.txt /i RBS-x64.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_Content" DBINSTANCE="DBInstanceName
    

將 RBS 用戶端程式庫安裝在所有其他前端及應用程式伺服器上To install the RBS client library on all additional front-end and application servers

  1. 確認執行這些步驟的使用者帳戶是安裝程式庫所在之電腦的系統管理員群組成員。Confirm that the user account performing these steps is a member of the Administrators group on the computer where you are installing the library.

  2. 在任何網頁伺服器上,針對 SharePoint Server 2016下載 Microsoft SQL Server 2014 Feature Pack。若要建立 X64 RBS.msi 檔案的安裝資料夾,請執行自我解壓縮下載套件。On any web server, for SharePoint Server 2016, download the Microsoft SQL Server 2014 Feature Pack. Run the self-extracting download package to create an installation folder for the X64 RBS.msi file.

    針對 SharePoint 2013,下載 RBS_amd64.msi 檔案For SharePoint 2013, download the RBS_amd64.msi file.

  3. 複製下列命令,並將其貼至命令提示字元視窗。將 WSS_Content 改成資料庫名稱,然後將 DBInstanceName 改成 SQL Server 執行個體名稱。作業約一分鐘內完成。Copy and paste the following command into the Command Prompt window. Replace WSS_Content with the database name, and replace DBInstanceName with the name of the SQL Server instance. The operation should finish within approximately one minute.

    msiexec /qn /lvx* rbs_install_log.txt /i RBS_x64.msi DBNAME="WSS_Content" DBINSTANCE="DBInstanceName" ADDLOCAL=Client,Docs,Maintainer,ServerScript,FilestreamClient,FilestreamServer
    
  4. 對 SharePoint 伺服器陣列中的所有網頁伺服器重複此程序。Repeat this procedure for all Web servers in the SharePoint farm.

  5. 在 SharePoint 伺服器陣列的每部應用程式伺服器上,執行下列命令:Run the following command on each application server in the SharePoint farm:

    Msiexec /qn /1vx* rbs_install_log.txt /I RBS_x64.msi ADDLOCAL="Client"
    

確認 RBS 用戶端文件庫安裝To confirm the RBS client library installation

  1. rbs_install_log.txt 記錄檔案會建立在 RBS_x64.msi 檔案所在的相同位置。請使用文字編輯器開啟 rbs_install_log.txt 記錄檔,然後捲動至檔案底部。檔案最後 20 行中應會包含下列項目: "Product: SQL Remote Blob Storage - Installation completed successfully"The rbs_install_log.txt log file is created in the same location as the RBS_x64.msi file. Open the rbs_install_log.txt log file by using a text editor and scroll toward the bottom of the file. Within the last 20 lines of the end of the file, an entry should read as follows: Product: SQL Remote Blob Storage - Installation completed successfully.

  2. 在執行 SQL Server 2014 Service Pack 1 (SP1) 或 SQL Server 2008 的電腦上,確認內容資料庫中是否已建立 RBS 資料表。內容資料庫下應列有數個名稱前加上 "mssqlrbs" 的資料表。On the computer that is running SQL Server 2014 Service Pack 1 (SP1) or SQL Server 2008, verify that the RBS tables were created in the content database. Several tables should be listed under the content database that have names that are preceded by the letters "mssqlrbs".

安裝協力廠商提供者Install the third-party provider

各個製造商安裝協力廠商提供者的步驟都不相同。請務必遵循提供者製造商的指示操作。The steps that you use to install the third-part provider will vary between manufacturers. Be sure to follow the instructions from the manufacturer of the provider.

啟用每個內容資料庫的 RBSEnable RBS for each content database

您必須在 SharePoint 伺服器陣列中啟用一部前端伺服器的 RBS。執行活動時,選取哪一部前端伺服器並不重要,只要使用上述程序在該伺服器上安裝 RBS 即可。您必須為每個內容資料庫執行此程序一次。You must enable RBS on one front-end server in the SharePoint farm. It is not important which front-end server that you select for this activity, as long as RBS was installed on it by using the previous procedure. You must perform this procedure one time for each content database.

注意

您只能使用 Microsoft PowerShell 啟用 RBS。You can only enable RBS by using Microsoft PowerShell.

使用 PowerShell 啟用 RBSTo enable RBS by using PowerShell

  1. 確認您具備下列成員身分:Verify that you have the following memberships:

    • SQL Server 執行個體上的 securityadmin 固定伺服器角色。securityadmin fixed server role on the SQL Server instance.

    • 所有要更新之資料庫上的 db_owner 固定資料庫角色。db_owner fixed database role on all databases that are to be updated.

    • 正在執行 PowerShell Cmdlet 之所在伺服器上的系統管理員群組。Administrators group on the server on which you are running the PowerShell cmdlets.

  2. 啟動 SharePoint 管理命令介面。Start the SharePoint Management Shell.

  3. 在 PowerShell 命令提示字元中,輸入下列命令:At the PowerShell command prompt, type the following command:

    $cdb = Get-SPContentDatabase <ContentDatabaseName>
    $rbss = $cdb.RemoteBlobStorageSettings
    $rbss.Installed()
    $rbss.Enable()
    $rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
    $rbss
    

    其中:Where:

    • <ContentDatabaseName> 是內容資料庫的名稱。<ContentDatabaseName> is the name of the content database.

如需詳細資訊,請參閱<Get-SPContentDatabase>。For more information, see Get-SPContentDatabase.

測試 RBS 安裝Test the RBS installation

您應該在 SharePoint 伺服器陣列中的一部網頁伺服器上測試 RBS 安裝,以確保系統可以正常運作。You should test the RBS installation on one Web server in the SharePoint farm to make sure that that the system works correctly.

測試 RBS 資料存放區To test the RBS data store

  1. 在包含「RBS 資料儲存」的電腦上按一下 [開始],再按一下 [電腦]。On the computer that contains the RBS data store, click Start, and then click Computer.

  2. 瀏覽至 RBS 資料儲存目錄。Browse to the RBS data store directory.

  3. 確認資料夾是空的。Confirm that the folder is empty.

  4. 在 SharePoint 伺服器陣列上,將檔案上傳至文件庫。On the SharePoint farm, upload a file to a document library.

  5. 在包含「RBS 資料儲存」的電腦上按一下 [開始],再按一下 [電腦]。On the computer that contains the RBS data store, click Start, and then click Computer.

  6. 瀏覽至 RBS 資料儲存目錄。Browse to the RBS data store directory.

  7. 瀏覽至檔案清單,然後開啟變更日期最新的檔案。這應該就是您剛才上傳的檔案。Browse to the file list and open the file that has the most recent changed date. This should be the file that you uploaded.

另請參閱See also

概念Concepts

SharePoint Server 中的 RBS 概觀Overview of RBS in SharePoint Server

決定在 SharePoint Server 中使用 RBSDeciding to use RBS in SharePoint Server

其他資源Other Resources

遠端 Blob 存放區 (RBS) (SQL Server)Remote Blob Store (RBS) (SQL Server)

啟用和設定 FILESTREAMEnable and Configure FILESTREAM