Load balancing for generating reports in AX 2012

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (0)

Suggested answer

guk1964 10,877 on at

Like (0)

Report

RE: Load balancing for generating reports in AX 2012

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Load balancing for generating reports in AX 2012

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

Pravasti AK 2,985 on at

Like (0)

Report

RE: Load balancing for generating reports in AX 2012

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.