Dynamics ax 2012 SSRS report rendering problem

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.

Advertisements

One Response to Dynamics ax 2012 SSRS report rendering problem

  1. Zulfiqar Ali says:

    Dear Amir,
    Nice One.

    I want to contact with you to learn microsoft dynamics ax 2009.
    just for 2 or three day’s.

    Please Contact:-
    Zulfiqar Ali
    +92-332-2451702

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: