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.

6 comments:

  1. 1) Don't use IP, but servername. If same server has something else listening on port 80 (like a website of some kind), use a different port: http://myserver:85/Reports_INSTANCENAME. (If installed with Default instance, just remove the instance name part.

    2) The business connector should not be added as user in AX. It is sufficient to add it as a system account under Administration\Setup\System\System Accounts.

    3) Make sure the business connector points at the AOS properly, yes.

    4) I normally make sure the servername is listed in *Local Intranet Zone* (ex http://servername/).

    Good luck!

    ReplyDelete
  2. Thank you for your suggestions, they are really useful.

    ReplyDelete
  3. Microsoft Dynamics AX training, do keep a few things in mind to get the maximum out of the course as well as the application.we teach Microsoft Dynamics AX training and class at Hyderabad. Microsoft Dynamics CRM training in Hyderabad, Microsoft Dynamics NAV training in Hyderabad

    ReplyDelete
  4. Microsoft Dynamics CRM training will help you manage and prioritize your business goals, customize.we teach MS Dynamics CRM training and class available at Hyderabad.Microsoft Dynamics AX training in Hyderabad, Microsoft Dynamics NAV training in Hyderabad

    ReplyDelete
  5. Microsoft Dynamics NAV training could be a lifelong asset for your role in a small or medium enterprise.NAV Technical, NAV Trade, NAV Finance.we teach Microsoft Dynamics NAV training and class available at Hyderabad. Microsoft Dynamics AX training in Hyderabad, Microsoft Dynamics CRM training in Hyderabad

    ReplyDelete
  6. You are doing a great job. You inspire me to write for other. This post is very well written and also well formatted.
    Oracle Fusion HCM Technical Online Training

    ReplyDelete