When you click on the Executive Center in Business Portal in Microsoft Dynamics GP, the error “The Request Failed with HTTP Status 401: Unauthorized” appears in the SQL Server Reporting Services web parts

Resolution 1:

1. At the web server where Business Portal is installed, right-click Start and then click Open Windows Explorer.

2. Go to C:\inetpub\wwwroot\wss\VirtualDirectories\<port>.  The placeholder <port> is the port number currently used for the Business Portal site.

3. Make a backup copy of the Web.config file.

4. Open the Web.config file in a text editor such as Notepad.

5. Find the following line:


6. Comment it out as follows:


7. Close and save the Web.config file.

8. Close and launch Business Portal again.  Click the Executive Center to verify if the HTTP: 401 Unauthorized error is resolved.



Resolution 2:

The Internet Explorer settings are configured for each user and for each workstation.  Please verify the following settings for each user that is launching Business Portal.

1. In Internet Explorer, click Tools, and then click Internet Options.

2. Click the Security tab.

3. Click Trusted Sites.

4. Click Sites.

5.  Verify the Business Portal root site is listed under the Websites: section.  For example, if the Business Portal site is http://servername:888/BP, the root site that must be listed is http://servername:888.

6. If the Business Portal root site is not listed, enter the site in the Add this website to zone area and click to deselect the Require sever verification (https) for all sites in this zone if you are not using Secure Socket Layers (SSL) for your Business Portal site.

7. Click Add.

8. Click Close.

9. In the Internet Options window, click OK.

10. Close and launch Business Portal again.  Click the Executive Center to verify if the HTTP: 401 Unauthorized error is resolved.


Resolution 3:

The Internet Explorer settings are configured for each user and for each workstation. Please verify the following settings for each user that is launching Business Portal.

1. In Internet Explorer, click Tools, and then click Internet Options.

2. Click the Advanced tab.

3. Verify the option Enable Integrated Windows Authentication is checked under the Security area.

4. Click OK.

5. If a change was made, close and launch Business Portal again. Click the Executive Center to verify if the HTTP: 401 Unauthorized error is resolved.


Resolution 4:

Depending on how the environment is configured, Kerberos may be required to authenticate the users when accessing the SQL Server Reporting Services. Please refer to the How To Article below to determine if Kerberos is required in your environment.

Customers
https://mbs.microsoft.com/customersource/documentation/howtodocuments/MD_HOWTO_VerifyKerberosRequirementBPBI

Partners
https://mbs.microsoft.com/partnersource/documentation/howtoarticles/MD_HOWTO_VerifyKerberosRequirementBPBI


Resolution 5:

This problem occurs because Windows includes a loopback check security feature that helps prevent reflection attacks on your computer. Therefore, authentication fails if the FQDN or the custom host header that you use does not match the local computer name.  Refer to the KnowledgeBase Article below to configure the BackConnectionHostNames value in the Windows Registry at each SQL Server Reporting Services server.
http://support.microsoft.com/kb/956158

Resolution 6:

Refer to the following article to configure the Windows Firewall for SQL Server Reporting Services.
http://msdn.microsoft.com/en-us/library/bb934283.aspx

Resolution 7:

The Microsoft.Dynamics.GP.ReportingServices.Common.ReportViewerSettings.config file is used by Business Portal 5.1 for Microsoft Dynamics GP 2010 to determine where the SQL Server Reporting Services reports are being stored.  This file is stored on the web server in the folder where the Business Portal IIS site components are located (e.g. C:\inetpub\wwwroot\wss\VirtualDirectories\80\bin).

There are four sections that could cause errors when attempting to view the SQL Server Reporting Services reports in Business Portal.  When the Business Intelligence feature for Business Portal is installed, the installer pulls the following values from the SY40800 table in the DYNAMICS database, which holds the information entered in the Reporting Tools Setup window within Microsoft Dynamics GP 2010 R2 and later:


This line holds the Web Service URL that is built from the Report Server URL field on the Reporting Tools Setup window.


This line specifies if you have deployed your SQL Server Reporting Services to a Native or SharePoint integrated site.  This is determined by the Report Server Mode drop-down field on the Reporting Tools Setup window.


This line is only used if you have a SharePoint integrated SSRS instance.  This is the SharePoint document library where your reports have been deployed to.  This is pulled from the Report Library field on the Reporting Tools Setup window.


There will be one occurrence of this line for every Microsoft Dynamics GP 2010 company that you have.

If any of these lines are incorrect you can receive the HTTP 401: Unauthorized error en Business Portal.  The most common issue is if you've moved your SQL Server Reporting Services instance to a new server or port after you've installed Business Portal.