PerformancePoint 2010 - The request failed with HTTP status 401: Unauthorized

If you've been working with PerformancePoint Services, and you've tried to create a data connection using either Excel Services or a SharePoint list, then you may encounter this error:

PerformancePoint Services could not connect to the specified data source.

Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration.
Also verify that all required connection information is provided and correct.
System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol. ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ListService.GetListCollection()at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ExcelServicesDataSourceProvider.GetDatabaseNames() PerformancePoint Services error code 201.

One possible cause is the LoopBackCheck. This is a feature first introduced in SP1 for Windows Server 2003 and has been included with Windows Server 2008 as well. The feature blocks a server from calling itself by host name, thus preventing a certain type of denial of service attack.  However, the feature doesn't play nicely with SharePoint. Most notably, it prevents the SharePoint indexer from crawling. It will also cause the error identified above.

You can disable it on Windows 2008 servers with this powershell script:


New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -value "1" -PropertyType dword


Permalink | Comments (0) | Post RSSRSS comment feed