web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Load balancing for gen...
Microsoft Dynamics AX (Archived)

Load balancing for generating reports in AX 2012

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

I am having 3 aos servers aos1,aos2,aos3 . I had done load balancing over there which works perfectly fine. I am facing problems while generating reports. In my ax- report servers parameters, I had done configurations for all three servers. 

Now i have different report server (i.e. Reporting server : RS) . In client configuration of RS , business connector is pointed to A0S2. When services for aos2 gets down, my report doesn't works. In this case if aos2 gets done it should switch to next aos i.e. aos1 or aos3. 

How could this be achieved, or is it possible to achieve this.

*This post is locked for comments

  • Suggested answer
    Pravasti AK Profile Picture
    Pravasti AK 2,985 on at

    Hi Mayur,

    You can distribute the user load in Microsoft Dynamics AX across multiple instances of Application Object

    Server (AOS) by creating a load balancing cluster.

  • Community Member Profile Picture
    Community Member on at

    HI kavitha,

    Yes for ax i can open multiple instances. But i want this should work for generating reports.

    on my report server business connector is pointed to only one aos2 , thats why when services for aos2 stops... then my reports don't execute.

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at

    SSRS does not scale unless you are on Enterprise version of SQL or the latest Sql2106 Sp1 -see the hardware specs.

    https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

    Scroll down near the bottom to the section Reporting Services Features

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans