Saturday 30 November 2013

An error has occurred during report processing.(rsProcessingAborted) in SSRS ax 2012

Dynamics ax 2012 SSRS report rendering problem, it is asking for userId and password, every time when it is launch.

During the SSRS report deployment, i run the report to test it, but is asking me for the userId and password. I think this is happend to me because i restore database from other machine, but i am not sure about the reason. After google on internet i got some help. I am publishing here what help i got.
Below is the screenshot of error i got while publishing the ssrs report.

How i have Solved this ?

The problem here is in a malconfigured SSRS server.
Open this config file rsreportserver.config usually located here:
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config
With in the config file, locate the <Authentication> tag, and make sure the only active tag in there is <RSWindowsNTLM />, ie:
 <Authentication>
  <AuthenticationTypes>
   <RSWindowsNTLM />
<!–
 comment out, or delete other tags, and keep <RSWindowsNTLM />
   <RSWindowsNegotiate/>
   <RSWindowsKerberos />
–>
  </AuthenticationTypes>
After you save the file you have to restart the Reporting server service. You can do this from Report server configuration. After that we have to redeployed the report by deleting the previous one available.

No comments:

Post a Comment