Trying to debug an issue with a data source, I am currently getting this error:
The error is occurring in my DataSet2, on this particular Dataset:
Looking at the logs, I see this:
Microsoft.ReportingServices.ReportProcessing.DataSetExecutionException: The execution failed for the shared data set 'DataSet2'.
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ''.
System.Data.SqlClient.SqlException: Invalid object name 'facilities'.`
My next step to figure this out is to open this DataSet and confirm the query. When I try to Edit in Report Builder
and it prompts me for my credentials. In this case, I am trying to use the sa
user, but it is telling me that my credentials are invalid.
I've confirmed on the actual SQL Server that the credentials are correct.
Any suggestions would be greatly appreciated.
It doesn't look related to the username SA
. The error suggests that the Dataset2
does not have the facilities
table.