New-SPAccessServiceApplication

Cria uma nova instância de um aplicativo dos Serviços do Access no SharePoint Server.

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

O New-SPAccessServiceApplication cmdlet cria uma nova instância de um aplicativo dos Serviços do Access no SharePoint Server 2010, SharePoint Server 2013. Depois que você criar um novo aplicativo de Serviços do Access, use o cmdlet Set-SPAccessServiceApplication para modificar as respectivas configurações globais.

Para obter as permissões e informações mais recentes sobre o Windows PowerShell para Produtos SharePoint, confira a documentação online em Cmdlets do SharePoint Server.

Exemplos

------------EXEMPLO 1----------------

New-SPAccessServiceApplication -Name "MyAccessService" -SPIisWebServiceApplicationPool MyAppPool

Este exemplo cria uma nova instância de Serviços do Access denominada MyAccessService que é executada no pool de aplicativos denominado MyAppPool.

------------EXEMPLO 2----------------

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

Este exemplo cria uma nova instância de Serviços do Access denominada MyAccessService que é executada no pool de aplicativos denominado MyAppPool, que permite até 25 sessões por usuário em cada computador back-end servidor de aplicativos em que os Serviços do Acesso são executados.

Parâmetros

-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

Especifica o pool de aplicativos do IIS (Serviços de Informações da Internet) a executar o serviço Web para o novo aplicativo de Serviços do Access.

O tipo deve ser uma instância válida de um objeto do 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.

O tipo deve ser um inteiro no intervalo de 1 a 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

Solicita sua confirmação antes de executar o comando. Para saber mais, digite o seguinte comando: 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

-Name

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.

O tipo deve ser um nome válido de um aplicativo de Serviços do Access; por exemplo, 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

-NonRemotableQueriesAllowed

Especifica que é possível executar as consultas que não podem ser realizadas remotamente na camada de banco de dados.

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

Especifica o número máximo de cláusulas Order By na consulta. O valor padrão é 4.

O tipo deve ser um inteiro no intervalo de 1 a 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

Especifica que as junções externas esquerdas e direitas são aceitas. As junções internas são sempre aceitas.

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.

O tipo deve ser um inteiro no intervalo de 1 a 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

-Padrão

Especifica que o aplicativo de serviço está associado a aplicativos Web adicionando o proxy desse aplicativo de serviço à lista de proxy padrão do farm.

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

-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.

O tipo deve ser o inteiro -1 ou um inteiro no intervalo de 1 a 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.

O tipo deve ser o inteiro -1 ou um inteiro no intervalo de 1 a 2073600 (24 dias)

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.

O tipo deve ser um inteiro no intervalo de 1 a 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.

O tipo deve ser o inteiro 0 ou um inteiro no intervalo de 1 a 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.

O tipo deve ser o inteiro -1 ou um inteiro no intervalo de 1 a 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.

O tipo deve ser o inteiro -1 ou um inteiro no intervalo de 1 a 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

Especifica o número máximo de listas que podem ser usadas como entrada em uma consulta por vez. O valor padrão é 8.

O tipo deve ser um inteiro no intervalo de 1 a 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

O tamanho máximo permitido em megabytes permitido para modelos do Access (arquivos de arquivo .accdt) carregados na galeria de soluções. Valores válidos: -1 (sem limite), de 1 a qualquer inteiro positivo.

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

Exibe uma mensagem que descreve o efeito do comando em vez de executar o comando. Para saber mais, digite o seguinte comando: 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