Raju's Dynamics AX / Dynamics 365 Finance and Operations Blog

When I open any report in AX 2012 R2 i get below error
“Unable to log on to Microsoft Dynamics AX.” or “Failed to Log On to Microsoft Dynamics AX”

If I check in Event Log i see below error.

An error has occurred during report processing. (rsProcessingAborted)

An error has occurred during report processing. (rsProcessingAborted)

Microsoft.Reporting.WinForms.ReportServerException
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

Query execution failed for dataset ‘SalesInvoiceDS’. (rsErrorExecutingCommand)

Microsoft.Reporting.WinForms.ReportServerException

An exception occurred in the query metadata execution. The exception is Unable to log on to Microsoft Dynamics AX..

Microsoft.Reporting.WinForms.ReportServerException

Unable to log on to Microsoft Dynamics AX.

Microsoft.Reporting.WinForms.ReportServerException

Unable to log on to Microsoft Dynamics AX.

Microsoft.Reporting.WinForms.ReportServerException

---

*****RESOLUTION*****: Go to server where you had SSRS and then click on start and type
“SQL SERVER REPORTING SERVICES CONFIGURATION MANAGER”

Open it > Then Make sure both Service account & Execution account are using same BusinessProxy Account.

---