Set-SPBusinessDataCatalogServiceApplication
設定伺服器陣列中之 Business Data Connectivity Service 應用程式的全域屬性。
Syntax
Set-SPBusinessDataCatalogServiceApplication
[-ApplicationPool <SPIisWebServiceApplicationPool>]
[-DatabaseCredentials <PSCredential>]
[-DatabaseName <String>]
[-DatabasePassword <SecureString>]
[-DatabaseServer <String>]
[-DatabaseUsername <String>]
[-FailoverDatabaseServer <String>]
-Identity <SPServiceApplicationPipeBind>
[-Name <String>]
[-Sharing]
[-Confirm]
[-WhatIf]
[-AssignmentCollection <SPAssignmentCollection>]
[<CommonParameters>] Description
此 Set-SPBusinessDataCatalogServiceApplication Cmdlet 會設定伺服器陣列中 Business Data Connectivity 服務應用程式的全域屬性。
如需適用於 SharePoint 產品的 Windows PowerShell 權限及最新資訊，請參閱線上文件 SharePoint Server Cmdlet。
範例
------------------範例------------------
$sa = Get-SPServiceApplication | ?{$_.TypeName -eq 'Business Data Connectivity Service Application'}
Set-SPBusinessDataCatalogServiceApplication -Identity $sa -FailoverDatabaseServer "CONTOSO\Backup"此範例會將容錯移轉資料庫伺服器設為指定服務應用程式的 CONTOSO\Backup。
參數
-ApplicationPool
指定新 Business Data Connectivity Service 應用程式所要使用的 IIS 應用程式集區。
| Type: | SPIisWebServiceApplicationPool |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-AssignmentCollection
{{Fill AssignmentCollection Description}}
| Type: | SPAssignmentCollection |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-Confirm
在執行命令之前，提示您確認操作。
如需詳細資訊，請輸入下列命令：get-help about_commonparameters。
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-DatabaseCredentials
指定包含要用於資料庫 SQL Server 驗證之使用者名稱及密碼的 PSCredential 物件。
此類型必須為有效的 PSCredential 物件。
| Type: | PSCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-DatabaseName
指定 Business Data Connectivity 資料庫的名稱。
此類型必須是有效的 SQL Server 資料庫名稱，例如 UsageLogDB1。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-DatabasePassword
指定 DatabaseUserName 中指定之使用者的密碼。 唯有在 SQL Server 驗證用於存取 Business Data Connectivity 資料庫時，才使用此參數。
此類型必須是有效的密碼。
| Type: | SecureString |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-DatabaseServer
指定 Business Data Connectivity 資料庫的名稱。
此類型必須是有效的 SQL Server 資料庫名稱，例如 UsageLogDB1。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-DatabaseUsername
指定用於連接目錄資料庫的使用者名稱。 唯有在 SQL Server 驗證用於存取 Business Data Connectivity 資料庫時，才使用此參數。
此類型必須是有效的使用者名稱，例如 UserName1。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-FailoverDatabaseServer
指定容錯移轉資料庫伺服器之主機伺服器的名稱。
此類型必須是有效的 SQL Server 主機名稱，例如 SQLServerHost1。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-Identity
指定與新 Proxy 相關聯的 Business Data Connectivity Service 應用程式。
| Type: | SPServiceApplicationPipeBind |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-Name
指定新 Business Data Connectivity Service 應用程式 Proxy 的顯示名稱。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-Sharing
指定在全伺服器陣列中發佈與共用 Business Data Connectivity Service 應用程式。
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |
-WhatIf
顯示訊息會描述命令的功效而不執行命令。
如需詳細資訊，請輸入下列命令：get-help about_commonparameters。
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
| Applies to: | SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019 |