Network Load Balancing Reporting Services with AX 2012 & SQL Server 2012

Microsoft SQL Server 2012

After following the “Configure a Report Server on a Network Load Balancing Cluster” article on TechNet, and generating my machine key from aspnetresources/machineKey I was able to apply the new Machine Key value to both of our load balanced Report Servers web.config file. In doing this, we ended up with a configuration that looks similar to what is pictured below.:

Reporting Server Configuration 1

When first launching into the instance of Microsoft Dynamics AX 2012, that had three AOSes, users had no issues executing report. Users, that is, that where connected to the first AOS that has a Reporting Services configuration associated with it.

Those Users trying to run an SSRS Report when connected to the any other AOS instances (ax102, ax103) would get the following error message.: “The default Report Server Configuration ID could not be found in the SRSServers table.” This error message was presented in an infolog, similar to the one pictured below.:

Report Error

To solve this problem, the answer was to create a Reporting Server Configuration for each AOS in the cluster by setting the Application Object Server Name to each AOS instance. In other words, 3 identical Server configurations except for the AOS Server name. Configuration ID 1 points to AX101, ID 2 points to AX102 and ID3 points to AX103 as seen below:

Reporting Server Configuration 2

Once there was a Report Configuration for each AOS instance all of the reports SSRS Reports would generate when a client was connected to any AOS. All reports where able to execute, no matter what AOS a user was logged into. Further each of the report server configurations where pointing to the NLB, or Network Load Balancing server name.

Having done this, we were able to take full advantage of SQL Server 2012, with a scaled out, load balanced reporting servers that better meets are reporting needs. This will further enable, as needed, future scale as our users demand more, and more reports from our Microsoft Dynamics AX 2012 instance.

Special Thanks to Brandon George, Microsoft Dynamics MVP for sponsoring my work on his blog: http://dynamics-ax.blogspot.com/2013/01/ax-2012-sql-server-2012-nlb-reporting.html