AX 2012 R3 - SSRS install

 

steps to install SSRS extensions:

- Install SQL server SSRS services first

- Using Reporting services configuration Manager, configure the reporting server, database and URL as shown below

Configure SQL Server Reporting Service 2016 (SSRS).

 Once the SSRS feature is installed successfully, you should configure it manually by doing the following:

Open Reporting Service Configuration Manager.

Connect to the Report Server Instance.

Review Report Server Status and make sure it's started.

In "Service Account", you will find the report server service account that runs the Report Server Service.

Go first to the "Database" section to configure the database that holds the all report server content and application data.

Note: in case you have deleted a report in reporting service, you can't restore it! the available options are

• you have a copy of the deleted report on your local machine so you can upload it again.
• you have a backup from the report database so you can restore it.

Click Change database to create the report server database for the first time.

Check Create a new report server database.

Make sure the database server is correct.

Set the authentication type as (Integrated User or SQL Server account). 

Note: this account must have permission to connect to the database server. 

Provide the correct account credentials.

Test the connection and make sure that the connection is established successfully.

Specify the database name as you prefer.

Specify the credentials of an existing account that the report server will use to connect to the report server database.

Review the summary information, and make sure that everything is set properly before proceeding.

Wait while the report server database wizard configures the database then click Finish.

Go back to configure the "Report Server Web Service URL".

• Set the Report Server Web Service URL virtual directory.
• Set the Report Server web service site identifications based on your requirements then click Apply.

Test the Report Server Web Service URL that should be now browsed properly.

Go now to the "Report Manager URL", specify the virtual directory as you prefer then click Apply to configure it.

Once the Report Manager Completed Successfully, Click the Report Manager URL to test it.

Great, it should be now browsed properly.

Note

If you got a permission issue to access report manager, please check SSRS 2016: You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.

Go now to the "Encryption keys".

Take a backup of the symmetric key that used to encrypt sensitive data in the report server database like connection strings, credentials ...etc. it will be helpful in case you migrate or move the report server installation to another server, you can restore this key to regain access to the encrypted content.