Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error: "The provided Secure Store target application is either incorrectly configured or does not exist" when saving a PowerPivot refresh schedule job

Error: "The provided Secure Store target application is either incorrectly configured or does not exist" when saving a PowerPivot refresh schedule job

View products that this article applies to.

Symptoms

A user logged into SharePoint 2010 (or later) uploads a PowerPivot workbook and chooses to schedule a data refresh for the workbook according to How to: Schedule PowerPivot workbook data refresh

Reference Step 7, choice C: The user enters a known existing Secure Store Target application ID in the Credentials section inside the "Connect using the credentials saved in Secure Store Service" field.

When the user clicks OK to save the schedule, the following error displays:

"The provided Secure Store target application is either incorrectly configured or does not exist"

↑ Back to the top

Cause

PowerPivot uses SharePoint's Secure Store methods to verify the user Administrative rights in Secure Store. The method used to check user permissions requires the user have at least one of these Secure Store Administrator rights before the Secure Store Target Application ID is acknowledged: Create, Manage, or Delete Secure Store Application.

↑ Back to the top

Workaround

Grant the user permissions using the Secure Store Administrators feature in Central Administration.

Steps:
In Central Administration browse to Application Management
Click Manage Service Applications
Click to the right of the Secure Store Application link so the row appears highlighted.
Click on the Administrators button and add the user attempting to edit the PowerPivot data refresh schedule (or an appropriate security group including user) to the field.  
Click Add, then check "Manage target applications".
Click OK

Finally, add the user to the Administrators group of the Secure Store target application you wish to use for the PowerPivot scheduled refresh. Refer to Step 11. in the "Create a target application" section: http://technet.microsoft.com/en-us/library/ee806866(v=office.14).aspx#section3

↑ Back to the top

Keywords: kb, commercialoff2010track

↑ Back to the top

Article Info
Article ID : 2487346
Revision : 4
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 285