question

ChristopherWhalen-6797 avatar image
0 Votes"
ChristopherWhalen-6797 asked Garth commented

sccm running reports permission issue

Hello, I am trying to run reports in sccm but I seem to have a account issue, the error below says bad username and PW, yet I am signed into the server and using the configuration manager. My sccm account has full admin permission. Here is the error message I receive when I try to run any report. Thank you.

199774-image.png


Microsoft.Reporting.WinForms.ReportServerException
An error has occurred during report processing. (rsProcessingAborted)


Stack Trace:
at Microsoft.Reporting.WinForms.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.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)



Microsoft.Reporting.WinForms.ReportServerException
Cannot impersonate user for data source 'AutoGen_5C6358F2_4BB6_4a1b_A16E_8D96795D8602'. (rsErrorImpersonatingUser)


Stack Trace:
at Microsoft.Reporting.WinForms.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.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)



Microsoft.Reporting.WinForms.ReportServerException
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)


Stack Trace:
at Microsoft.Reporting.WinForms.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.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)



Microsoft.Reporting.WinForms.ReportServerException
The user name or password is incorrect


Stack Trace:
at Microsoft.Reporting.WinForms.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.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)



mem-cm-general
image.png (156.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Garth avatar image
0 Votes"
Garth answered Garth commented

First enabled remote errors . https://askgarth.com/blog/how-to-enable-remote-errors/
Next view the report from the web site.

Next check the service account details within cm console.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Garth, I have had the SQl person enable that remote errors setting.

I get this error when I try to run the report, I'm not sure the account it is trying to use, how would I find that out? Thanks.

An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'AutoGen_5C6358F2_4BB6_4a1b_A16E_8D96795D8602'. (rsErrorImpersonatingUser)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
The user name or password is incorrect

I also tried to edit a report and I receive this:
200306-image.png


Our SQL admin just gave me full permissions to the SQL reporting portal. I have logged into it and can view all the reports but I still get the login/pw issue when I try to click on any of the reports. I asked the head SQL guy if he gets this error also when he runs a report and yes he does as well.

200346-image.png


0 Votes 0 ·
image.png (98.7 KiB)
Garth avatar image Garth ChristopherWhalen-6797 ·

The error means that there is an authentication issue, did you check that you enter the connection account username and password correctly? Did you review Sql logs to see if it is an issue with talking to the dc?

0 Votes 0 ·
kalyansundar-6796 avatar image
0 Votes"
kalyansundar-6796 answered

Kindly install download and install report builder manually and try to edit the report.

For the above error, Check reporting role properties and re-input correct reporting service point account

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.