It seems New-SPPerformancePointServiceApplication cmdlet does not have -databaseName parameter as other cmdlets to create a service apps. I wonder if it is possible to create PerformancePoint services with custom database name via PowerShell?

If you run this command with the required parameters:

New-SPPerformancePointServiceApplication -Name "PerformancePointServices" -ApplicationPool "ServiceAppPool"

New Performance Point service app will be created and it's database name will be PerformancePointServices_GUID. I would like to be able to create a database with a custom name (without guid :))

4 Answers 4


sorry - known issue - for PPS you can't do this. learn to love the GUIDs!

  • LOL, if you say so that that's it! We tried with DB rename and then update with Set-SPPerformancePointServiceApplication but such ServiceApp has problems with updates etc. Jul 27, 2010 at 9:27

Todd Carter's post "The Wizard Likes His GUIDs" provides a PowerShell script that is supposed to create GUID-less database names. There is no explicitly set database name in his script but perhaps it uses the service application name?

You might also like to try AutoSPInstaller but I can't see PerformancePoint deployed at all in that.

  • Nope the Wizard also uses New-SPPerformancePointServiceApplication that appends GUID. It seems like a deadend to me :( May 26, 2010 at 9:40

This issue was fixed in Service Pack 1. New-SPPerformancePointServiceApplication now includes DatabaseName and DatabaseServer parameters.



Unfortunately Todd's script doesn't do it, you still end up with a GUID, and according to this blog: Deploying PerformancePoint 2010 Soup to Nuts it is not possible.

Shame, as I just can't wait for the first time I run across a need to install to a managed SQL instance where all databases must be pre-provisioned!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.