To integrate Microsoft Dynamics AX and Reporting Services, you must register your Reporting Services server. To do so, complete the following procedure using your Microsoft Dynamics AX client.

Note Note

If the Reporting Services server is using the Secure Sockets Layer (SSL) of IIS, the Microsoft Dynamics AX client computer that you use for this procedure must have the SSL certificate installed on it.

  1. Open the Reporting Serversform ( Microsoft Dynamics AXmenu > Tools> Business Intelligence (BI) tools> Reporting Servers).

  2. Click the Overviewtab.

  3. In the Server namefield, enter the name of the server on which Reporting Services is installed.

  4. In the Descriptionfield, enter a description to distinguish this server from other report servers (if applicable). For example, if you have a report server for each country in which you operate, you may want to enter Spain report serveror France report server.

  5. In the Web service URLfield, enter the URL to the Report Server virtual directory.

    • If you are using SSL on your report server, the URL is https://ServerName/reportserver.

    • If you are not using SSL, the URL is http://ServerName/reportserver.

  6. In the Report Manager URLfield, enter the URL to the Report Manager virtual directory.

    • If you are using SSL on your report server, the URL is https://ServerName/reports.

    • If you are not using SSL, the URL is http://ServerName/reports.

  7. Click the Advancedtab.

  8. Enter a name for a report folder. This report folder will be created for you in Reporting Services.

  9. Enter a name for a data source. This data source will be created for you in Reporting Services.

    Important Important

    This data source has read access to your entire Microsoft Dynamics AX database. This data source should be used only for ad hoc reporting. Be sure to secure this data source using SQL Server Reporting Services tools. See the SQL Server documentation on MSDNfor detailed conceptual information and step-by-step tutorials that will help you administer security in Reporting Services.

  10. Click the Createbutton to create the report folder and data source.

  11. Click Validateto verify that the folder and data source have been created.

    If the validation fails, do the following:

    • Verify the name of the report server in the Server namefield.

    • Verify that Reporting Services is running.

    • Verify in IIS (on the report server) that the DefaultAppPoolis running.

    • If you are using SSL on your report server, verify that the SSL certificate is stored in the local computer's certificate store. For more information, see the IIS documentation.