question

DavidChase-4918 avatar image
0 Votes"
DavidChase-4918 asked davidchase-4554 commented

SSRS Shared Dataset 2nd web

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)

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered DavidChase-4918 commented

Hi @DavidChase-4918
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.
113147-01.jpg

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.



01.jpg (55.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What about using an SQL Server user and password instead of windows user and password?

0 Votes 0 ·
DavidChase-4918 avatar image
0 Votes"
DavidChase-4918 answered davidchase-4554 commented

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.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If you need custom authentication, you cannot use the Custom authentication type with the default Windows authentication extension.

Anonymous authentication directs the report server to ignore authentication header in an HTTP request. The report server accepts all requests, but call on a custom ASP.NET Forms authentication that you provide to authenticate the user.

In addition, the report server does not support anonymous authentication methods. The report server will not accept unauthenticated requests from an anonymous user, except for those deployments that include a custom authentication extension.

Report Builder will accept unauthenticated requests if you enable Report Builder access on a report server that is configured for Basic authentication.

For all other cases, anonymous requests are rejected with an HTTP Status 401 Access Denied error before the request reaches ASP.NET.

0 Votes 0 ·

What if I use SQL Server login rather than windows authentication?

0 Votes 0 ·

So what is the solution?

0 Votes 0 ·