Showing posts with label AX SSRS. Show all posts
Showing posts with label AX SSRS. Show all posts

Wednesday, February 15, 2012

Enable remote errors on SSRS



Query:


I am getting some errors when viewing SSRS reports on client machines but i can not see the full error because it is asking me to enable remote errors on ssrs. How can i do that on ssrs 2005.

Answer:
The setting is stored in the table named 'ConfigurationInfo ' on the report server. Just open the table and set Enable Remote Errors to true.

Tuesday, November 8, 2011

RPC 5 Exception

Question :
I am running SSRS 2008 R2 with Dynamics ax under network services user. Issue is sometimes the reports show up and sometimes they do not. I notice that i have few error with RPC 5 exception in my event log.

Answer :
This is a know issue. To fix this for SSRS 2008 remove the execution account from SSRS configuration manager and run the SSRS service under BC Proxy account. 

Dynamics AX SSRS The request failed with HTTP status 401

Question : 
I am receiving a 401 error when connecting to AX Reports hosted on SSRS 2008 R2.


Answer :
The solution that worked for me was to open rsreportserver.config file placed in the reporting services instalaltion directory, finding authentication group and commenting WindowsNegotiate tag as shown below.

 
   
   
 
  true

Tuesday, January 4, 2011

AL.exe is not installed

Query :
I am deploying the reports on the reporting server but getting the following error, "AL.exe is not installed"

Answer:
This is because you have not installed the .Net SDK, install it from here, http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e6e1c3df-a74f-4207-8586-711ebe331cdc&displaylang=en, and you should be good.