11 April, 2014

401 unauthorized + Dashboard Designer + PerformancePoint: SharePoint2010/SharePoint2013

I think I am loving this functionality i.e. PerformancePoint Services as every time i tried doing something then always get some new error message. This time also I got this error while trying to launch the dashboard designer:

Error message#1: 401 unauthorized

Error message#2: The remote server returned an error: (401) Unauthorized

How to reproduce this issue?
1.   Open your business intelligence (BI) site
2.   You will see a button on the home page named as Dashboard Designer
3.   Click on it and BOOM
4.   You will get the above mentioned error message.

Troubleshooting done:
1.   Tried in Internet explorer, Mozilla Firefox and Google chrome but all the giving me the same error message.
2.   I don’t have a multiple domains so avoiding the possibility of dashboard not recognizing the credentials
3.   There is no chance of permissions here as I am already having site collection admin access.
4.   ULS logs and event logs

I have checked the ULS and found the found details:

BrowserSettings browserSettings, String& errorPageUrl)
   at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
  --- Inner Exception ---
  System.Net.WebException
  - The remote server returned an error: (401) Unauthorized.
  - Source: System
  - Stack trace:
   at System.Net.HttpWebRequest.GetResponse()
   at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

After lot of trial and exception, found the following details which are ultimately a resolution.

Resolution#1:
1.   Open your SharePoint site
2.   When it prompts for credentials then please check the option
3.   Remember my credentials
4.   That’s it- you will be able to launch “Dashboard Designer” without any issues.

Resolution#2:
1.   Open this link and follow the instructions (windows 7)
3.   Save your credentials and check the results.

Resolution#3:
1.   Open a blank IE (internet explorer)
2.   Tools
3.   Internet options
4.   Security
5.   Local Intranet -> sites -> add your site here ->click OK only once
6.   Coming back to security tab ->custom level
7.   Scroll towards the bottom
8.   Select prompt for username and password
9.   Click OK completely -> close the browser -> open a new IE ->open the BI site and check the results.

In case of 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.

Note:
If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product applies to:
- SharePoint 2010
- SharePoint 2013 

References:
An error occurred during the processing of /PerformancePoint/Pages/ppssample.aspx. Code blocks are not allowed in this file http://sharepointknowledgebase.blogspot.com/2013/11/code-blocks-are-not-allowed-in-this.html

We're sorry. We ran into a problem completing your request. Please try that again in a few minutes:
http://sharepointknowledgebase.blogspot.com/2014/04/were-sorry-we-ran-into-problem.html

Unattended service account for PerformancePoint
http://sharepointknowledgebase.blogspot.com/2013/10/unattended-service-account-for.html

This data source cannot be used because performancePoint services is not configured http://sharepointknowledgebase.blogspot.com/2013/10/this-data-source-cannot-be-used-because.html

Cannot connect to PerformancePoint Services in SharePoint 2010 http://sharepointknowledgebase.blogspot.com/2013/07/cannot-connect-to-performancepoint.html

Performance Point Service could not connect to the specified data source
http://sharepointknowledgebase.blogspot.com/2014/04/performance-point-service-could-not.html 

No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.