Yesterday, i was configuring Schedule PowerPivot Data
Refresh as per this microsoft article:
What i
did exactly ?
-Open a
SharePoint 2010 site
-Uploads
Powerpivot
-selects
schedule a data refresh for the workbook
-at step 7, i
have selected third option i.e. 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.
-Clicks OK to
save the schedule and got the following error message:
"The
provided Secure Store target application is either incorrectly configured or
does not exist"
I have
successfully resolved this issue by following the below mentioned steps:
Note: I am still debugging this issue to find
out the root cause. Will share the details asap.
Resolution
Steps:
1.
In
Central Administration browse to Application Management
2.
Click
Manage Service Applications
3.
Click
to the right of the Secure Store Application link so the row appears
highlighted. The objective is to activate the Administrators button in the menu
ribbon.
4.
Click
on the Administrators button and add the user (or an appropriate
security group including user) to the field.
5.
Click
Add, and then check the "Manage target applications" check box.
If you have any
queries/questions then please let me know. I would be more than happy to help
you as well as resolves your issues, Thank you
