New-SPAccessServiceApplication

在 SharePoint Server 中建立 Access Services 應用程式的新實例。

Syntax

New-SPAccessServiceApplication
   [-Name <String>]
   -ApplicationPool <SPIisWebServiceApplicationPoolPipeBind>
   [-AssignmentCollection <SPAssignmentCollection>]
   [-CacheTimeout <Int32>]
   [-ColumnsMax <Int32>]
   [-Confirm]
   [-Default]
   [-NonRemotableQueriesAllowed]
   [-OrderByMax <Int32>]
   [-OuterJoinsAllowed]
   [-OutputCalculatedColumnsMax <Int32>]
   [-PrivateBytesMax <Int32>]
   [-RecordsInTableMax <Int32>]
   [-RequestDurationMax <Int32>]
   [-RowsMax <Int32>]
   [-SessionMemoryMax <Int32>]
   [-SessionsPerAnonymousUserMax <Int32>]
   [-SessionsPerUserMax <Int32>]
   [-SourcesMax <Int32>]
   [-TemplateSizeMax <Int32>]
   [-WhatIf]
   [-ApplicationLogSizeMax <Int32>]
   [<CommonParameters>]

Description

New-SPAccessServiceApplication Cmdlet 會在 SharePoint Server 2010 SharePoint Server 2013 中建立 Access Services 應用程式的新實例。 建立新的 Access Services 應用程式之後,請使用 Set-SPAccessServiceApplication Cmdlet 來修改其全域設定。

如需適用於 SharePoint 產品的 Windows PowerShell 權限及最新資訊,請參閱線上文件 SharePoint Server Cmdlet

範例

------------範例 1----------------

New-SPAccessServiceApplication -Name "MyAccessService" -SPIisWebServiceApplicationPool MyAppPool

此範例會建立一個名為 MyAccessService 的新 Access Services 執行個體,這會在名為 MyAppPool 的應用程式集區之下執行。

------------範例 2----------------

New-SPAccessServiceApplication -Name "MyAccessService" -SPIisWebServiceApplicationPool MyAppPool -SessionsPerUserMax 25

此範例會建立一個名為 MyAccessService 的新 Access Services 執行個體,這會在名為 MyAppPool 的應用程式集區之下執行,且會允許每個執行 Access Services 之後端應用程式伺服器機器上的每一位使用者,最多可以有 25 個工作階段。

參數

-ApplicationLogSizeMax

Specifies the maximum number of records for an Access Services Application Log list. Valid valies: -1 to maxint. 0 means none are allowed. The default value is 3000.

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

-ApplicationPool

這會為新的 Access Services 應用程式,指定要執行 Web 服務的現有 Internet Information Services (IIS) 應用程式集區。

其類型必須為 SPIisWebServiceApplicationPool 物件的有效執行個體。

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

-AssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

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

-CacheTimeout

Specifies the number of seconds that a data cache will remain active on Access Services with no user activity. Valid values include: -1, cache never times out; 1 to 2073600, cache remains active from 1 second to 24 days.

The type must be the integers -1, or an integer in the range of 1 to 2073600 (24 days). The default value is 300.

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

-ColumnsMax

Specifies the maximum number of columns that a list involved in a query can contain, or that the output of the query can contain. The default value is 30.

其類型必須為整數,且介於 1 到 255 之間

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
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
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-Default

指定服務應用程式與 Web 應用程式相關聯,方法是將此服務應用程式的 Proxy 新增至伺服器陣列的預設 Proxy 清單。

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

-NonRemotableQueriesAllowed

這會指定無法從遠端傳送至資料庫層的查詢,都可以執行。

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

-OrderByMax

這會指定查詢中的 Order By 子句數目的上限。 預設值為 4。

其類型必須為整數,且介於 1 到 8 之間。

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

-OuterJoinsAllowed

這會指定可支援右外部聯結。 內部聯結一律支援。

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

-OutputCalculatedColumnsMax

Specifies the maximum number of calculated columns that can be included in the output as a part of the query. Calculated columns in the underlying list are not included. The default value is 10.

其類型必須為整數,且介於 1 到 32 之間。

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

-PrivateBytesMax

Specifies the maximum private bytes in megabytes (MB) that can be used by Access Services. When set to -1, Access Services defaults to 75 percent of physical memory on the machine. Valid values are -1 (no limit), and from 1 to any positive integer.The default value is -1.

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

-RecordsInTableMax

Specifies the maximum number of records allowed for a table in the Access Services application. Valid values include: -1, no limit, and 1 to any positive integer. The default value is 500000.

其類型必須是整數 -1,或是介於 1 到 MaxInt 的整數。

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

-RequestDurationMax

Specifies the maximum number of seconds that a request to perform an operation can use before the request times out. Valid values include: -1, no limit, 1 to 2073600, cache remains active 1 second to 24 days. The default value is 30.

其類型必須是整數 -1,或是介於 1 到 2073600 (24 天) 的整數

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

-RowsMax

Specifies the maximum number of rows that a list involved in a query can have, or that the output of the query can have. The default value is 50000.

其類型必須為整數,且介於 1 到 200000 之間。

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

-SessionMemoryMax

Specifies the maximum allowable size, in megabytes, of an individual session. Valid values include 0, disable property, and 1 to 4095. The default value is 64.

其類型必須為整數 0,或是介於 1 到 4095 的整數。

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

-SessionsPerAnonymousUserMax

Specifies the maximum number of sessions allowed per user. If this maximum is reached, the oldest session will be deleted when a new session is started. Valid values include: -1, no limit, and 1 to any positive integer. The default value is 10.

其類型必須是整數 -1,或是介於 1 到 MaxInt 的整數。

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

-SessionsPerUserMax

Specifies the maximum number of sessions allowed per user. If this maximum is reached, the oldest session will be deleted when a new session is started. Valid values include: -1, no limit, and 1 to any positive integer. The default value is 10.

其類型必須是整數 -1,或是介於 1 到 MaxInt 的整數。

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

-SourcesMax

這會指定要使用清單做為查詢的輸入時,每次可使用的清單數目上限。 預設值為 8。

其類型必須為整數,且介於 1 到 20 之間。

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

-TemplateSizeMax

) 上傳至方案庫的 Access 範本 (.accdt 檔案,允許的最大允許大小以 MB 為單位。 有效值為:-1 (無限制),以及從 1 到任何正整數。

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
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
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-名稱

Specifies the display name of the Access Services application to create. The name can contain a maximum of 128 characters and can contain the comma (,), equal sign (=), or colon (:) characters provided they are enclosed in quotation marks.

其類型必須為 Access Services 應用程式的有效名稱;例如 AccessSrvApp1。

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