reporting-servicesssrs-2008ssrs-2008-r2

Unable to connect to data source using 'sa' user name


Trying to debug an issue with a data source, I am currently getting this error:

enter image description here

The error is occurring in my DataSet2, on this particular Dataset:

enter image description here

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.

enter image description here

I've confirmed on the actual SQL Server that the credentials are correct.

Any suggestions would be greatly appreciated.


Solution

  • It doesn't look related to the username SA. The error suggests that the Dataset2 does not have the facilities table.