Configure SQL Server Reporting Services for an on-premises deployment

Use the steps in this topic to configure SQL Server Reporting Services (SSRS) for your Microsoft Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) deployment.

  1. Open the Reporting Services Configuration Manager application.
  2. Leave the default Server name, which should be the name of the current machine, and the Report Server Instance, MSSQLSERVER.
  3. Click Connect.

    Reporting services configuration connection

  4. Click the Service Account tab and verify that the settings match the following graphic.

    Service account tab

  5. Click the Web Service URL tab and verify that the settings match the following graphic.

    Web service URL tab

  6. Click the Database tab and verify that the Database Name and Credential settings match the following graphic. Note: You will need to create a new database. To do this, click Change Database, and then verify that the new database name is: DynamicsAxReportServer.

    database tab

  7. Click the Web Portal URL tab and verify that the settings match the following graphic. Note: You must click Apply to create and properly configure the Portal.

    web portal url tab

    After the Portal is configured, the Web Portal tab will match the following graphic. web portal tab

  8. Click the reports URL to view the SQL Server Reporting Services web portal.

  9. When you are in the portal, create a new folder named Dynamics.

    dynamics folder

  10. In the Reporting Services Configuration Manager, click the E-mail Settings tab and verify that the settings match the following graphic.

    email settings tab

  11. Click the Execution Account tab and verify that the settings match the following graphic.

    execution account tab

    Don’t change the default settings on the Encryption Keys tab. encryption keys tab

  12. Click the Subscription Settings tab, and verify that the settings match the following graphic.

    subscription settings tab

    Don’t change the default settings on the Scale-out Deployment tab. scale-out deployment tab

    Don’t change the default settings on the Power BI Integration tab. power bi integration tab

  13. Click Exit to close the Reporting Services Configuration Manager.

    close reporting services configuration manager