.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

PerformancePoint 2010 - Denied Access to Existing Data Source

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

We have SharePoint 2010 farm using Kerberos for authentication that works fine for almost all scenarios, except this last issue we see with PerformancePoint and the Dashboard Designer.

When our Data Connections library is empty I can start the Dashboard Designer and create a New Data Source. Clicking on Save the data source is saved in the correct location (default PPS library).

However, once I do an action that requires the Dashboard Designer to read the list of data sources from this library I get an access issue. This could be by trying to create a report using the saved data source or by closing the Dashboard Designer and opening it again to create a data source.

This error is logged in the ULS log and Event Viewer:

The user "domain\loginname" attempted to access an item in the following location: http://sp-server/PWA/ProjectBICenter/Data Connections for PerformancePoint


View Complete Post

More Related Resource Links

PerformancePoint 2010 - SharePoint Lists as a data source


I am in the midsts of planning for an upgrade from 2007 to 2010, and we are looking for quick-wins for the client, one of which obviously being PerformancePoint 2010 integration with SPS 2010. So i am tooling around, following some basic tutorials of creating scorecards/kpis/filters/dashboards all from the contoso sample data, which is all fine and well, but my client doesn't have a datawarehouse, and doesn't plan on moving to one.

This puts me in the situation where I need to be able to create these pieces from SP Lists instead of an analysis services DB/DW. I go through and create the data connection, and all seems to be working fine...In the data connection windows, I can click the View tab and preview the data, and actually see all the data thats in the task list I've created and linked to (all demo data, just created a couple of tasks and etc).

Now the trouble comes when I try to create a simple scorecard based off of this list. When I am in the Create tab, and click Scorecard, (Use Tabular > SP List) I can select my data source (Task Tracking Data Source) and thats all well and good.

I then go to the SharePoint Site tab (on the select data source on the wizard), I am able to select my Task Tracking Data source as well. When I get to the KPI scre

Quick Note: Create Silverlight Applications to Access SharePoint 2010 Data

In this exercise, you will learn how to create Silverlight applications to display SharePoint 2010 lists inside DataGrid controls.

Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Developer Training: Data Access in Technologies in SharePoint 2010

Learn about the new data access technologies in SharePoint 2010 and how they can help increase your productivity. This training module covers the basics of LINQ handling and how to use the Client OM and REST to access SharePoint 2010 information remotely.

Quick Note (Scenario): Getting Started with Data Access in SharePoint 2010

The goal of these exercises is to give you the steps that you need to access data from various sources by using web development tools and technologies such as SharePoint 2010 and Visual Studio 2010.

SQL Server doesn't exist or access denied while connecting with Access 2010 ODBC

Hello all. I am using Access 2010 and SQL Server 2008 (locally). I can easily connect to server using SSMS and it works excellent. But when I want to import a table to Access 2010 using ODBC, it says that "SQL Server doesn't exist or access denied". It worked previously - almost 3 days ago, but now, it doesn't! Please help! Thanks Mohammad Javahery

VS 2010 and data source issues

I've been banging my head against the wall for the past 4 hours on this one and think I'm going to need a little help here. I must be missing something. I'm in VS 2010 on Windows 7. I've got a web project which has been going fine, but no matter what I do I can't get a data source to show up in the Data Source window. I've added a data source using Data > Add New Data Source, and the "wizard" appeared to complete successfully. I have a data source showing in my solution explorer, and if I open the .xsd file I see all my tables from a remote SQL 2005 database. I have a good data connection to the database server showing up in the Server Explorer window. But no matter what I do I cannot get anything to appear in the Data Sources window, which is greyed out (the commands at the top are grayed out and there's gray text in the middle of the window reading "There are no data sources to show for the selected project"). Under the main Data menu at the top of VS, the "Show Data Sources" and "Add New Data Source" commands are missing. I can sometimes get them to reappear if I restart Visual Studio or reboot the OS, but not consistently. I've been all over Google on this and have tried every suggested solution I can find, to no avail. Anybody have any ideas? Thanks.

custom timer job Access denied sharepoint 2010

Hi, I have a question regarding to custom timer job will be happy if you could help us. The problem is that - owstimer.exe running the timer job crashes. - Question why? Launch debugg in the feature - running the timer job is falling on taskJob.Update (); writes SecurityException  I developed the Job TIMER on moss2007 that everything worked, Now we turned from 2007 to sharepoint 2010 and Job TIMER does not work. I tried to note all of the code is inside the function Execute in  job timer might have something to code blocks. But it also did not help. Eventvwr he writes in the following error: The description for Event ID 0 from source Application can not be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: Custom Timer Jobs: func FeatureActivated Access denied. the message resource is present but the message is not found in the string / message table what the solution to that-timer job that will work? Thank you Moshes

Search Server Express 2010 - Access Denied when attempting to manage Search Service Application or P

I first noticed this error with the Search Service Application when I was no longer able to use the search portal, but have since noticed the issue with the PowerPoint Service Application.  When I navigate in Central Administration to either the "Farm Search Administration" or the "Manage service applications" pages and attempt to manage the "Search Service Application", I get this error: Error: Access Denied  Current User You are currently signed in as:  WHEELERS\MyUserName   Sign in as a different user    I have tried removing the service application and re-adding it, changing the application pool to running under an existing application pool as the farm administrator, as another application pool with the same identity as the primary web application, and as another application pool running under the SP-SearchService identity. The big recent change with SharePoint, aside from fixing the previous issue where I was incorrectly using CNAMEs with Kerberos, was to switch the main web application to claims authentication. That site correctly works with claims based authentication and Kerberos.

I need to create a script in SSIS which creates a data source that connects to an Access database.

I need to create a script in SSIS which creates a data source that connects to an Access database. The Access database file name needs to be set as a variable as it will change from month to month. I have no idea what I am doing can anybody give me some tips? Mr Shaw

Sharepoint 2010 Multi-Tenancy Access Denied on Tenant Administration Site

Hi, I am currently implementing a Sharepoint 2010 Multi-Tenancy solution. Multi-tenancy is the partitioning of service applications in 2010 to allow data to be separated between web applications or site collections. I am using multi-tenancy to separate data and user profiles between site collections hosted on a single web application. I have partitioned the User Profile Service Application and Proxy using Windows Powershell. The paritioned Proxy Application is then associated with the single web application. I am also using the Sharepoint Foundation Subscription Service Application to subscribe to different site collections within the web application. In this way data and user profiles can be separated. However, the tenant administration site, used to manage each collection, does not allow administrator access to manage the User Profile Service. I receive a standard Sharepoint 'Access Denied' error message. No other errors or details are provided. I have tried assigning different accounts to the tenant administration site but the error still appears. The issue arises when I issue the following SPSite Powershell cmdlet: NEW-SPSite -Owneralias DOMAIN\Username -Secondaryowneralias DOMAIN\Username. The attributes provided in the Cmdlet above are used to assign tenant site administrators however, the accounts cannot access the User Profile Service. Any ideas or recommendati

Access Denied/The workflow could not copy the item workflow error after Sharepoint 2010 upgrade

We have a sharepoint designer workflow that copies a document from one library to another on the same site.  Before the upgrade to 2007 it worked fine, but now with 2010 it gives an error and cancels the workflow when it gets to the copy list item step.   The error on the workflow page: The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings.  Access Denied   Specifically it is the "copy list item current item to documentlibrary" sharepoint designer workflow action.   I have given the system account full permissions to the library and double checked that all columns are the same in both libraries. These are the verbose trace logs:   09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72er Medium System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>Access denied. at Microsoft.SharePoint.SPFile.UpdateInternal(Boolean migrationSemantics, Boolean reGhost) at Microsoft.SharePoint.Workflow.SPWinOEWSSService.CommitCopyFile(Transaction txn, Object[] transData) 09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72fe High Error in commiting pending workflow batch items: Sys

Is it possible to configure an existing sub site as variation source label in 2010?

Hi, I am trying to configure variations on an existing site. For example, I already have a site collection and a sub site "en-us" that has all the content. Would it be possible to configure this existing "en-us" as my variation source site? If not possible, can anyone suggest me any work-around? This is very critical and hopefully there is a way to achieve this without having to move all the content from "en-us" to my top level site, create variation labels with different names, and then delete the content from top-level site. Please suggest. Thanks, Karthik    

REST Connection Data Source is getting overriddeen by SPD 2010

Hi, I used a Linked Datasource consist of two REST Connection Data Source with the credentials saving with the data source. The first time i add the Data View to the Web Part Zone everything is fine and the data is shown fine but the moment i save it and close the aspx page and open it again, SPD overrides and adds some of the attributes in the DataSources tag, which makes it giving an error saying connection problem and if i copy paste the original Datasource tag with the values it works fine. Any Idea guy's i am just fighting with this from 2 days. Thanks Girish

Error: Access Denied on default.aspx and other pages of existing and new sites

Hi, since today we can't access the project portals of all our projects (Visual Studio TFS 2008/sharepoint admin 3.0 running on esx 4.0). I already checked every possible security settings, they're all OK. I also tried creating a new site but I can't access the site. I can however access all the settings. For example when I try to access: http://server/Sites/Profel I get the "Error: Access Denied" message and the browser is redirected to http://server/Sites/Profel/_layouts/AccessDenied.aspx?Source=http%3A%2F%2Fserver%2FSites%2FProfel%2Fdefault%2Easpx I have no problem navigating to: http://server/sites/Profel/_layouts/settings.aspx and I can go to al lot of pages, but when I want to create something like a calendar I can specify the parameters but when I click the create button I get the same error. http://server/Sites/Profel/_layouts/AccessDenied.aspx?Source=http%3A%2F%2Fserver%2FSites%2FProfel%2FLists%2Ftest%2Fcalendar%2Easpx&Type=list&name=%7B46CB3B46%2DD0F6%2D47F5%2DBA1A%2D3C9654A24A8E%7D I already tried this: http://support.microsoft.com/kb/926642  http://support.microsoft.com/kb/896861/en-us but no success Any help is welcome, Greetz, Peter

VS 2010 Express can't add SQLEXPRESS Data Source

Hi all, I've spent a couple of days on this now and have tried everything I can find on the web to fix this issue. I can add Access data sources to VS 2010 Express, but can't find how to add SQL Server 2008 Express data sources. I keep getting the "40" and "26" errors.   I am running both VS2010 and SQLServer on a local machine, no network connection involved. I have granted corrected permissions in SQLServer. I have opened the correct ports, set the correct protocols, ensured my SQLServer is open for remote connections and changed my windows firewall settings. My question relates to the "Advanced" window in the data source wizard - it refers to .\SQLEXPRESS. I have noticed that this service is not running in my SQL Server Configuration manager and cannot even be started. I also do not have an Express SQL Server Browser at all! (I had one yesterday before I reinstalled SQL Server for the 3rd time!). Could this be the source of the problem? (the .\SQLEXPRESS) ? Thanks in advance for any help, Henry
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend