SSRS Shared Dataset 2nd web

Question

We have an intranet website and a public website and would like to use some of the reports in the public website. When I try to print a SSRS report in the public website I get the error below. How can i allow the shared dataset to be used by the public website?

Process information:
Process ID: 15916
Process name: w3wp.exe
Account name: NT AUTHORITY\SYSTEM

Exception information:
Exception type: SoapException
Exception message: System.Web.Services.Protocols.SoapException: The report server cannot process the report or shared dataset. The shared data source 'BodyShopDS' for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceReferenceException: The report server cannot process the report or shared dataset. The shared data source 'BodyShopDS' for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo3& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
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.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ReportExecutionService.LoadReport(String Report, String HistoryID)
at FilesClass.CreatePDFReport(String strReportName, Int32 intRecordID, Int16 intType) in E:\shared\apps\RepairTrak\App_Code\FilesClass.vb:line 364
at orders_FinalBillReports.Page_Load(Object sender, EventArgs e) in E:\shared\apps\RepairTrak\Repairs\FinalBillReports.aspx.vb:line 67
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Answer 1

Hi @David Chase ，
It seems that the reason why the shared data source cannot be connected can not be seen from the error report.
You try to check whether the Connection string is correct in the data source management, and the authentication method is as shown in the figure, and finally test the connection.

We have an intranet website and a public website and would like to use some of the reports in the public website

I don’t understand what you mean by " an intranet website and a public website". I think you should describe the previous operation in as much detail as possible.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
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.

Answer 2

What you show is EXACTLY how our shared dataset is setup and I even used the "Test Connection" button and it responded with 'Connected successfully'.

The SSRS reports are being used in a Windows Authentication website (intranet) and now we want to use it on Anonymous Authentication site. We have been using the SSRS reports on the Windows Authentication website for 15 years.