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:
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.
- SSRS Expression Divide by Zero Error
- Using DevExpress XtraReport Constructor with parameter
- SSRS report expression issue
- Could not load assembly Microsoft.ReportViewer.Common, despite installing the prerequisites
- Unable to upload rdl SSRS 2016
- Fill Color based on Cell Value
- =WeekdayName(weekday(Today())) gives me tomorrow
- Dynamic formatting in SSRS matrix column cells
- SSRS Report Server - Email on failure?
- Location to place favicon for report viewer / report manager
- ssrs error Maximum request length exceeded
- Tablix: Repeat header rows on each page not working
- User defined filters and sorting options for report builder
- SSRS Query execution failed for dataset
- SSRS How to repeat the table header on each page in print preview
- curl with NTLM succeeds but HttpClient with NTLM credentials fails 401
- SSRS Dynamic column names
- How to open an .rdl file in Visual Studio
- How do I add a character at the end of a field to get the total to 100 characters?
- SSRS Formatting for negative numbers
- The operation cannot be started by an account that uses SQL Server Authentication error When running ssis from stored proc in SSRS
- SSRS - When navigating to a linked website or report, then navigate back, lose scroll position and parameters
- SSRS Web Service URL Provides an Error (500)
- Horizontally and vertically Totals in RDLC Matrix
- ssrs group label repeating on the next page
- IIF condition in Stimulsoft Reporting Tool
- VS2022 - report project incompatible with current version of Visual Studio
- How to make LookupSet display results in many rows
- Unable to connect to data source using 'sa' user name
- How to create a csv file using SSRS with 2 distinct header rows and 2 rows of data for each record (template format in question)