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

{{Fill in the Description}}

Examples

Example 1

PS C:\>New-SPAccessServicesApplication -DatabaseServer SQLServerName -ApplicationPool 'SharePoint Web Services Default' -Name 'Access Services Service Application' -Default

Creates an Access Services Service Application.

Required 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
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016
-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
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016
-Default

Add to default Service Application Proxy group.

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

Optional Parameters

-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 (ByValue)
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016
-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
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2013, SharePoint Server 2016
-Confirm

Prompts you for confirmation before running the cmdlet.

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

Specifies the credentials used to log into the database server.

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

{{Fill Encrypt Description}}

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

{{Fill Hosted Description}}

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

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

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

{{Fill RecoveryPointObjective Description}}

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

{{Fill TrustServerCertificate Description}}

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

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

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

Inputs

Microsoft.SharePoint.PowerShell.SPIisWebServiceApplicationPoolPipeBind

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Outputs

System.Object