Export (0) Print
Expand All

New-PowerPivotSystemServiceInstance cmdlet

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Adds a new instance of Power Pivot System Service to an application server.

Applies To: SharePoint 2010 and SharePoint 2013.

New-PowerPivotSystemServiceInstance [[-ParentService] <PowerPivotMidTierServicePipeBind>] [-SystemServiceInstanceName <string>] [-Provision] [<CommonParameters>]

The New-PowerPivotSystemServiceInstance cmdlet provisions a new PowerPivotSystemService object at the farm-level after you have used SQL Server Setup to install Power Pivot for SharePoint on the local application server. You can only provision one service instance on each application server. If the service is already provisioned, you cannot run this cmdlet.

-ParentService <PowerPivotMidTierServicePipeBind>

Specifies the GUID of the Power Pivot System Service parent object in the farm. In this release, there is only one parent object allowed. You can use Get-PowerPivotSystemService to return the service object or its GUID.

Required?

false

Position?

0

Default value

Accept pipeline input?

true

Accept wildcard characters?

false

-SystemServiceInstanceName <string>

Specifies a name that identifies this object.

Required?

false

Position?

1

Default value

Accept pipeline input?

false

Accept wildcard characters?

false

Provision [<SwitchParameter>]

Makes the service available on SharePoint. Valid values are $true or $false.

Required?

false

Position?

named

Default value

Accept pipeline input?

false

Accept wildcard characters?

false

<CommonParameters>

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

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.

Inputs

None.

Outputs

None.

C:\PS>New-PowerPivotSystemServiceInstance -Provision:$true

This example shows the most common form of the cmdlet. It registers the Power Pivot System Service on the local application server with the farm.

C:\PS>New-PowerPivotSystemServiceInstance -SystemServiceInstanceName "MyPSSInstance" -provision:$false

This example names the Power Pivot System Service instance, but without provisioning it. If you do not provide a name, the default name, SQL Server Analysis Services System Service Instance, is used instead. Creating a custom name for the service is optional. You might name the service to support test scenarios, or if you have a custom tool or script that provisions the instance in a later step.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft