New-SPAccessServicesDatabaseServer

參考

模組:: SharePointServer

適用於:: SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

新增伺服器以裝載 Access Services 資料庫。

Syntax

New-SPAccessServicesDatabaseServer
   [-ServiceContext] <SPServiceContextPipeBind>
   [-AssignmentCollection <SPAssignmentCollection>]
   [-AvailableForCreate <Boolean>]
   [-Confirm]
   [-DatabaseServerCredentials <PSCredential>]
   [-DatabaseServerGroupName <String>]
   -DatabaseServerName <String>
   [-Encrypt <Boolean>]
   [-Exclusive <Boolean>]
   [-SecondaryDatabaseServerName <String>]
   [-ServerReferenceId <Guid>]
   [-TrustServerCertificate <Boolean>]
   [-UserDomain <String>]
   [-ValidateServer <Boolean>]
   [-WhatIf]
   [-LoginType <LoginType>]
   [-State <DatabaseServerStates>]
   [-StateOwner <ServerStateOwner>]
   [<CommonParameters>]

Description

此 Cmdlet 會新增其他 Access Services 資料庫伺服器來裝載 Access Services 資料庫。

範例

範例 1

New-SPAccessServicesDatabaseServer -ServiceContext https://siteUrl -DatabaseServerName SQLSVR01 -ValidateServer:$true

本範例會使用網站的內容，將名為 SQLSVR01 的SQL Server新增為 Access Services 資料庫伺服器。https://siteUrl. 這也會驗證 SQLSVR01 能夠裝載 Access Services 資料庫。

參數

-AssignmentCollection

管理物件以適當處置它們。使用 SPWeb 或 SPSite 等物件可能會耗用大量的記憶體，因此在 Windows PowerShell 指令碼中使用這些物件時，必須適當地管理記憶體。您可以使用 SPAssignment 物件將物件指派給變數，並在不需要時處置這些物件，以釋放記憶體。使用 SPWeb、SPSite 或 SPSiteAdministration 物件時，若未使用指派集合或 Global 參數，將會自動處置這些物件。

使用 Global 參數時，所有物件會包含在全域儲存區內。若未立即使用物件，或未使用 Stop-SPAssignment 命令處置物件，將會發生記憶體不足的狀況。

Type:	SPAssignmentCollection
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-AvailableForCreate

指出SQL Server是否可用來建立 Access Services 資料庫。預設值為 true。

Type:	Boolean
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-Confirm

執行 Cmdlet 之前提示您確認。

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServerCredentials

指定用來連線至SQL Server的認證。

Type:	PSCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServerGroupName

指定 Access Services 資料庫組名。預設值為 DEFAULT。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServerName

指定要加入的SQL Server名稱。

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-Encrypt

指定在 Access Services 與裝載 Access Services 資料庫的SQL Server之間使用 SSL 加密。

Type:	Boolean
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-Exclusive

如果SQL Server已將 AvaliableForCreate 設定為 False，這會將其更新為 True。如果SQL Server識別碼不符合資料庫伺服器識別碼，且伺服器的 AvailableForCreate 設定為 True，這會將 AvailableForCreate 設定為 False。

Type:	Boolean
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-LoginType

表示登入類型。有效值為：

ApplicationLogin
LocalDBApplicationLogin
ServerLogin
StorageAccountLogon
WindowsAzureServerLogin

預設值為 ServerLogin。

Type:	LoginType
Accepted values:	ApplicationLogin, LocalDBApplicationLogin, ServerLogin, StorageAccountLogon, WindowsAzureServerLogin
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2016, SharePoint Server 2019

-SecondaryDatabaseServerName

指定要與新SQL Server產生關聯的次要SQL Server。這用於災害復原用途。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ServerReferenceId

提供特定的伺服器參考識別碼。根據預設，新增SQL Server時會自動產生伺服器參考識別碼。

Type:	Guid
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ServiceContext

指定要從中擷取 Access Services 資訊的服務內容。

Type:	SPServiceContextPipeBind
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-State

指出要加入之SQL Server的可用性。有效值為：

作用中
鎖定
保留

預設值為 Active。

Type:	DatabaseServerStates
Accepted values:	Active, Locked, Reserved
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2016, SharePoint Server 2019

-StateOwner

指定狀態擁有者。有效值為：

NoOwner
TenantMove

預設值為 NoOwner。

Type:	ServerStateOwner
Accepted values:	NoOwner, TenantMove
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2016, SharePoint Server 2019

-TrustServerCertificate

設定值，指出通道是否會在略過憑證鏈結以驗證信任時加密。

Type:	Boolean
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-UserDomain

指定要用於認證的網域。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ValidateServer

驗證SQL Server處於支援狀態，以裝載 Access Services 資料庫。

Type:	Boolean
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-WhatIf

顯示執行 Cmdlet 時會發生什麼情況。未執行 Cmdlet。

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False
Applies to:	SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

輸入

Microsoft.SharePoint.PowerShell.SPServiceContextPipeBind

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

輸出

System.Object

共用方式為