Configure SQL Server Reporting Services for on-premises deployments

Use the steps in this article to configure SQL Server Reporting Services (SSRS) for your Microsoft Dynamics 365 Finance + Operations (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.