Information Technology: AX2012R3 Report Server and Analysis Server step by step Installation and configuration.

Please find the below step by step AX2012R3 Report Server Installation and configuration.

Step: 1

Install the SQL Server Reporting service and configure the reporting Service Configuration Manager. Also from the below window make sure the left pane all step was configured correctly.

Make sure the following configuration of SSRS:

Service account must be configured with the domain account.

Web service URL must be configured with default or custom port, and the URL must accessible.

Database must be configured to the database server.

Report manager URL must be configured with default or custom ports, and the URL must be accessible.

Execution account must be configured with the same above mentioned domain user account.

IMPORTANT: - AX application business connector proxy user account, SSRS service user account and SSRS execution user account, all these three user accounts must be configured with the same domain user account.

Step: 2

Configure the Report server from AX application under system administratoràSetupàBusiness intelligenceàReport Server.

Once the configuration is done please click on the validate settings, you will be prompted to create the folder, please click on the create report folder and then validate setting and check you got the success massage as below, if you face any issue try to application with Run as Administrator option and validate it again.

Make sure the following settings in Report server configuration: -

Server Name field enter the SSRS server name.

Server Instance name enter instance name (Default Instance is MSSQLSERVER and if any named instance you can mention same here).

Report manager URL, enter the configured URL in the above steps (Step1).

Web service URL, enter the configured URL in the above steps (Step1).

Application Object server, Select your application object server instance.

Step: 3

Run the AX2012R3 Installation media, click on the Microsoft Dynamics AX components.

Step: 4

Please click on the next button to progress the installation.

Step: 5

Please click on the Add or modify components, then go with the next button.

Step: 6

Select the Business Intelligence components, and go with the next button.

Step: 7

Prerequisite validation will guide you know the tools need to be configured and installed.

Step: 8

Select the configure check box and then click on the configure button then click on the start button to configure the ADOMD.NET tools.

Step: 9

Click on the Revalidate button to check if any error still exists, the go with the next button.

Step: 10

Please enter the Business connector user account password, and go with the next button.

Step: 11

Select the SSAS Service name from the dropdown, and go with the next button.

Step: 12

Please select SSRS Instance name from the dropdown and if you need to deploy the Report with this installation enable the deploy Reports check box and then go with the next button.

Step: 13

Enter or select the AX application Database server name and ax database name.

Step: 14

Please enter the current user ssas service account user and any other user if required, then go with the next button.

Step: 15

Please check for the prerequisite validation again before installing the components, then go with the next button.

Step: 16

Please verify the selected Bl components, then go with the install button.

Step:17

Post installation configuration tasks will be performed.

Step: 18

Make sure the AX Bl components were installed successfully.

Step: 19

In the above steps, if Deploy reports is enable then the following steps will be automatically process and the administrator rights will be verified, also logged on must have the administrator rights to deploy the reports.