Sharepoint and SSRS Webpart issue

Question

Hi,

Wanting to run SSRS reports via a Sharepoint SSRS Webpart. When I choose load parameters get a 401 not authorised.

SSRS resides on a different server to Sharepoint and the database is on a different server again.

Struggling to get this to work, any help appreciated. Can managed to get this to work using a page webpart and adding the toolbar=false in the querystring but when I change toolbar=false to true I get another error saying cannot connect.

Any help would be appreciated.

Answer 1

Hi @MERCER, David (DEVON PARTNERSHIP NHS TRUST),

Thank you for posting in this community.

You can take the following approach to troubleshoot your problem:

1.This issue may occur if the SharePoint Web Application ASP.Net Impersonation status has been enabled in IIS. You can disable this ASP.Net Impersonation and check if the problem still persists.

Reference: The request failed with HTTP status 401 Unauthorized.

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

2.This error may occur when the Report Viewer control cannot authenticate to the SSRS server. I noticed that your SSRS server and Share Point server are not on the same computer. You can try the following steps:

• Check if you can connect to the SSRS server and the data source directly using SQL Server Management Studio (SSMS).
• Verify that the SSRS server is configured for SharePoint integrated mode and that you have granted database access to the SSRS server in Central Administration. Here is the article about configuring SSRS in SharePoint integrated mode: Install the first Report Server in SharePoint mode.
• Are you using Kerberos authentication? If so, please make sure you have configured the SPNs correctly for the report server and the database server. If not, you can follow this article to Configure SQL Server Reporting Services in SharePoint Server for Kerberos authentication.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.