Microsoft Dynamics AX 2012 & D365 F&O Blog For Microsoft ERP Business Solution : AX2012R3 Report Server and Analysis Server Step by Step Installation and Configuration

Thursday, 11 September 2014

AX2012R3 Report Server and Analysis Server Step by Step Installation and Configuration

Hi Folks,

Please find the below step by step AX2012R3 report server installation and configuration.

Step 1 :-

Install the SQL Server Reporting Services and Configure the Reporting Services Configuration Manager.Also from the below window make sure the left pane all steps were configured correctly.

Make sure the following configuration for SSRS:-

Service Account must be configured with the domain user account

Web Service Url must be configured with default or custom ports, and the URL must be 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 form in 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 created the folder, please click on the Create Report Folder and then Validate Settings and check you got the success message as below, if you face any issue try to open the 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 the instance name(Default instance is MSSQLSERVER and if any named instance you can mention same here)

Report Manager Url, enter the configured ur in the above steps(Step1)

Web Service Url, enter the configured ur 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, then go with the Next button.

Step 7:- Prerequisite validations will guide you know the tools needs 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 tool.

Step 9:- Click on the Revalidate button to check if any error stills exist, then go with the Next button.

Step 10:- Please enter the Business connector user account password, then go with the Next button.

Step 11:- Select the SSAS Service name from the dropdown, then go with the Next button.

Step 12:- Please select the 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 add the current user and ssas service account user and anyother 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 BI components, then go with the Install button.

Step 17:- Post installation configuration tasks will be performed.

Step 18:- Make sure the AX BI components were installed successfully.

Step 19:- In the above steps, if Deploy Reports is enabled then the following steps will be automatically processed and the administrator rights will be verified, also logged on must have the administrator rights to deploy the report.