Dynamics AX 2012
SQL Server provides many opportunities to share resources and improve the availability of your report server. Use the following resources to plan and implement a scale-out deployment for use with Dynamics AX 2012.
A SQL Server Reporting Services (SSRS) scale-out deployment includes two or more report server instances that share a single report server database. By using a scale-out deployment, you can increase the number of users who can access reports at the same time, and improve the availability of the report server.
Configuring a SQL Server Reporting Services scale-out deployment to run on a Network Load Balancing cluster – White Paper outlining the steps for deploying two or more report server instances that share a single report database.
You can install multiple instances of Microsoft SQL Server Reporting Services on the same computer. In this kind of deployment environment, each instance of Reporting Services is connected to an independent Microsoft Dynamics AX installation. You may want to install multiple instances of Reporting Services on the same computer to:
Support development and production installations of Microsoft Dynamics AX.
Support multiple production installations of Microsoft Dynamics AX.
Install multiple instances of Reporting Services on the same computer – Captures the administrative process involved in setting up an environment that has multiple Reporting Services instances on the same computer.