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)

2.   http://windows.microsoft.com/en-us/windows-vista/manage-stored-passwords

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