PerformancePoint 2007 Standalone + Vista = Permission Issues

"An expert is a man who has made all the mistakes which can be made, in a narrow field." Niels Henrik David Bohr
This almost perfectly describes my experience getting PerformancePoint Server 2007 running in standalone mode on my Vista laptop.  Should you ever find yourself in a similar position, please refer to the resources below.
First Nick Barclay has an excellent post on setting the correct Application Pool permissions.
Second, User Account Control will bite you.  Your choices are disable it all together (and cause your IT support staff to suffer cerebral aneurysm).  Alternatively, you can ensure the user executing any Dashboard Designer previews (and publishing) has access to the Preview directory.  If you did a next, next, next install of PPS, this would be C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\Preview.
Here we go again with Vista UAC.  If you have problems creating a new data connection, and you have opened your (local) db to the entire world.  This is where you should look.  There could be an issue with PPS actually granting members of the Administrators group, on Vista, access as Admin to the monitoring server. 
You can verify your authorization by selecting Options from the Office menu and using the Connect button in the resulting dialog.

Please or Register to post comments.

IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottOur Experts will show you:
• Common SQL Server
Problems
• Best Practices for T-SQL
• SQL Server Integration
Services
• Database Development

Come See Mike Otey & Tim Ford in Person!

Early Registration Now Open

From the Blogs
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
Vision road sign
May 6, 2013
blog

Cheaters Never Win, Even in TPC Benchmarks

In this portion of the series on database benchmarking, I want to tell you about one of my favorite aspects of the TPC benchmarks – CHEATING....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.