Sunday, November 20, 2011

Dynamics AX 2009 + SSRS Lessons Learned

Following are the lessons i have learned when configuring SSRS for AX 2009,

1- Always use IP address for connecting to SSRS
2- Add both the business connector user and the client connecting user as AX users, for instance if your bc user is proxy and the client connecting is newclient both the ID's should be in AX.
3- Make sure the business connector is configured properly.
4 -Make sure that SSRS URL is under trusted sites.

Tuesday, November 15, 2011

app.config editor

Question:


Is there any application around which I can use to update app.config files associated with .Net applications.


Answer:


The best application I have found is hosted on code project, http://www.codeproject.com/KB/files/AppConigEditor.aspx

Wednesday, November 9, 2011

Dynamics AX 2009 Known Issues

Question  :


Is there a place to review all the knows Dynamics AX 2009 Issues ?


Answer:


Yes, kindly review the following link.
http://dynamicspost.blogspot.com/2011/04/ax-2009-known-issues-solutions.html

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