New-SPAccessServicesApplication

Creates an Access Services Service Application.

Syntax

New-SPAccessServicesApplication
   -ApplicationPool <SPIisWebServiceApplicationPoolPipeBind>
   [-AssignmentCollection <SPAssignmentCollection>]
   [-CacheTimeout <Int32>]
   [-Confirm]
   -DatabaseServer <String>
   [-DatabaseServerCredentials <PSCredential>]
   [-Default]
   [-Encrypt <Boolean>]
   [-Hosted <Boolean>]
   [-Name <String>]
   [-PrivateBytesMax <Int32>]
   [-QueryTimeout <Int32>]
   [-RecoveryPointObjective <Int32>]
   [-RequestDurationMax <Int32>]
   [-SessionsPerAnonymousUserMax <Int32>]
   [-SessionsPerUserMax <Int32>]
   [-TrustServerCertificate <Boolean>]
   [-WhatIf]
   [<CommonParameters>]
New-SPAccessServicesApplication
   -ApplicationPool <SPIisWebServiceApplicationPoolPipeBind>
   [-AssignmentCollection <SPAssignmentCollection>]
   [-CacheTimeout <Int32>]
   [-Confirm]
   [-Default]
   [-Hosted <Boolean>]
   [-Name <String>]
   [-PrivateBytesMax <Int32>]
   [-QueryTimeout <Int32>]
   [-RecoveryPointObjective <Int32>]
   [-RequestDurationMax <Int32>]
   [-SessionsPerAnonymousUserMax <Int32>]
   [-SessionsPerUserMax <Int32>]
   [-WhatIf]
   [<CommonParameters>]

Description

Creates an Access Services Service Application.

Examples

Example 1

New-SPAccessServicesApplication -DatabaseServer SQLServerName -ApplicationPool 'SharePoint Web Services Default' -Name 'Access Services Service Application' -Default

Creates an Access Services Service Application.

Parameters

-ApplicationPool

Specifies the existing IIS application pool in which to run the Web service for the service application.

The type must be a valid GUID, in the form 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of an application pool (for example, AppPoolName1); or an instance of a valid IISWebServiceApplicationPool object.

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

-CacheTimeout

The maximum time (in seconds) that a data cache can remain available, as measured from the end of each request for data in that cache.

Valid values: -1 (indicates no limit); 1 through 2073600 (24 days).

Type:Int32
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

Prompts you for confirmation before running the 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

-DatabaseServer

Specifies the name of the host server for the database specified in DatabaseName.

The type must be a valid SQL Server host name; for example, SERVER\Database.

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

-DatabaseServerCredentials

Specifies the credentials used to log into the database 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

-Default

Add to default Service Application Proxy group.

Type:SwitchParameter
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

Specifies to use SSL encryption between Access Services and the SQL Server hosting Access Services databases.

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

-Hosted

Not used.

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

-Name

Specifies the name of the Access Services Service Application to create.

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

-PrivateBytesMax

The maximum number of private bytes (in MB) allocated by the Access Services process.

Valid values: -1 (the limit is set to 50% of physical memory on the machine), any positive integer.

Type:Int32
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

-QueryTimeout

Maximum time in seconds for a database command or query to execute before it is cancelled.

Valid values: 0 (indicates no limit); 1 through 2073600 (24 days). Recommended value is 60.

Type:Int32
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

-RecoveryPointObjective

Not used.

Type:Int32
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

-RequestDurationMax

The maximum duration (in seconds) allowed for a request from an application.

Valid values: -1 (indicates no limit); 1 through 2073600 (24 days).

Type:Int32
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

-SessionsPerAnonymousUserMax

The maximum number of sessions allowed per anonymous user. If this maximum is hit the oldest session will be deleted when a new session is started.

Valid values: -1 (no limit), 1 to any positive integer.

Type:Int32
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

-SessionsPerUserMax

The maximum number of sessions allowed per user. If a user has this many sessions and starts a new session, the user's oldest session is deleted.

Valid values: -1 (no limit), from 1 to any positive integer.

Type:Int32
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

-TrustServerCertificate

Sets a value that indicates whether the channel will be encrypted while bypassing walking the certificate chain to validate trust.

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

Shows what would happen if the cmdlet runs. The cmdlet is not run.

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

Inputs

Microsoft.SharePoint.PowerShell.SPIisWebServiceApplicationPoolPipeBind

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Outputs

System.Object