New-PowerPivotServiceApplication cmdlet

Creates a new PowerPivot service application.

Syntax

New-PowerPivotServiceApplication [-ServiceApplicationName] <string> [-DatabaseServerName] <string> [-DatabaseName] <string> [-AddToDefaultProxyGroup <switch>] [<CommonParameters>]

Description

The New-PowerPivotServiceApplication cmdlet creates a new PowerPivot service application in the farm. You must define at least one service application, and it must be a member of the default proxy service group. Optionally, you can create additional service applications if you need to vary properties or configuration settings. Additional service applications must be assigned membership to custom service connection groups. Only one PowerPivot service application can be a member of the default proxy group.

A new service application is created using a default configuration. To customize the configuration properties, use the Set-PowerPivotServiceApplication cmdlet.

Parameters

-ServiceApplicationName <string>

Sets the display name of the service application.

-DatabaseServerName <string>

Specifies a SQL Server relational database engine instance that hosts the application database. By default, you can use the farm's database server, or you can choose another database server for which you have create database rights.

-DatabaseName <string>

Specifies the name of a SQL Server relational database that stores application data. Be sure to specify a name that corresponds to the application so that you can more easily identify its purpose. You can create a new database or specify an existing PowerPivot service application database for the new application you are creating.

-AddToDefaultProxyGroup <switch>

Creates a PowerPivot service connection in the default service connection group. Associations between web applications and service applications are determined by membership in this group. All web applications that subscribe to the default service connection group can use the PowerPivot service application that you add to the group. Although you can have multiple PowerPivot service applications in a farm, only one service application can be a member of the default service connection group.

If you already have one PowerPivot service application that is a member of the default proxy group, you must set AddToDefautlProxyGroup:$false for the new application you are creating. You will need to add the new service application to a custom service connection group. You can use built-in SharePoint cmdlets for this purpose. Get-SPServiceApplicationProxyGroup returns the list of service connection groups that are defined in the farm.

<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable,OutBuffer and OutVariable. For more information, see About_CommonParameters.

Inputs and Outputs

The input type is the type of the objects that you can pipe to the cmdlet. The return type is the type of the objects that the cmdlet returns.

Example 1

C:\PS>New-PowerPivotServiceApplication -ServiceApplicationName "PowerPivot Service Application" -DatabaseServerName "AdvWorks-SRV01\PowerPivot" -DatabaseName "PowerPivotServiceApp1" -AddtoDefaultProxyGroup:$true

This example creates a new service application. The service application database is created on a database server named AdvWorks-SRV01 that was installed as a PowerPivot named instance, a common configuration for many PowerPivot for SharePoint installations. You must have dbcreator permissions on the SQL Server instance to create the database. You must be db_owner on the SharePoint configuration database. Because this is the first PowerPivot service application in the farm, it must be a member of the default proxy group.