SCOM Cannot initialize report

Question

Just about 3 Weeks back I ran this Availability report it worked I have been using this report without any Issues in the past but just last week I tried to run the report and I got this error below, the services are all up and running no password changes were performed against the accounts no changes that I know About have been Changed. This is the error that I get when I try to run the report

Date: 4/26/2023 3:16:38 PM
Application: Operations Manager
Application Version: 10.19.10569.0
Severity: Error
Message: Cannot initialize report.

Microsoft.Reporting.WinForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WinForms.ReportServerException: Cannot create a connection to data source 'DataWarehouseMain'. (rsErrorOpeningConnection) ---> Microsoft.Reporting.WinForms.ReportServerException: Login failed for user ''.
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at Microsoft.Reporting.WinForms.SoapReportExecutionService.ServerReportSoapProxy.OnSoapException(SoapException e)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
   at Microsoft.Reporting.WinForms.SoapReportExecutionService.LoadReport(String report, String historyId)
   at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
   at Microsoft.Reporting.WinForms.ServerReport.GetParameters()
   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)
   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)
Microsoft.Reporting.WinForms.ReportServerException: Cannot create a connection to data source 'DataWarehouseMain'. (rsErrorOpeningConnection) ---> Microsoft.Reporting.WinForms.ReportServerException: Login failed for user ''.
   --- End of inner exception stack trace ---
Microsoft.Reporting.WinForms.ReportServerException: Login failed for user ''.

Answer 1

Hi,

• An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WinForms.ReportServerException: Cannot create a connection to data source 'DataWarehouseMain'. (rsErrorOpeningConnection) ---> Microsoft.Reporting.WinForms.ReportServerException: Login failed for user ''.

Please use the reporting services configuration manager to verify that SSRS is configured correctly.

Confirm that the report server website is configured correctly. To view the site configuration setting, start the reporting service configuration manager, verify the URL in report server web services URLS in the web service URL section.