Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


PerformancePoint error - Cannot connect to data source

Posted on 2010-01-11
Medium Priority
Last Modified: 2012-06-21
We recently installed PerformancePoint on a dev server to try it out. I have Dashboard Designer on my desktop, and SharePoint is installed on a different server. I am trying to create a data source connection to a SharePoint list, and am getting this error:

The PerformancePoint Server could not connect to the specified data source. Verify that either the current user or application pool user has Read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

When I enter the url to the SharePoint site, it populates the drop-down with all the lists on that site, and I can choose the list I want. But if I click "Test Connection," I get the error.

The PPSMonitoringCentral, PPSMonitoringPreview, and PPSMonitoringWebService app pools are all using a domain account for their identity. The domain account has Full Control to the list on SharePoint.

How can I resolve this?
Question by:MercyHousing
  • 2
LVL 19

Accepted Solution

MsShadow earned 1000 total points
ID: 26291457
The application pool of your performance point server must run under the same identity as the application pool of SharePoint. That should do the trick.

Author Comment

ID: 26294261
If I change the PerformancePoint application pool identity to match the SharePoint application pool identity, I get this error when trying to connect to PerformancePoint:

Unable to connect to the specified server.  Make sure the address is correct.

I made sure that the domain account is a member of the Admin and Data Source Manager roles on the PerformancePoint server. Currently, the only way I can even connect to the server is to use either the Network Service or the previous domain account identity (which is not the same as the SharePoint identity) for the PerformancePoint application pools.

Author Comment

ID: 26376237
I figured out my mistake - I was attempting to connect to our other SharePoint server, which doesn't have the PerformancePoint components installed yet. Sorry!

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an article on how to answer questions, earn points and become an expert.
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question