Today Reinhard in the process of using the report, the following error was found:
The default report Server Configuration ID could is found in the Srsservers table.
based on the error message,Reinhard infers that this is caused by an incorrect report server configuration in Microsoft Dynamics AX. When one of the following situations occurs, we need to adjust or add the report server configuration:
- A new AOS is installed: After you install the new AOS, you need to tell the AOS which report server it should use.
- moved the report server to another physical host : In this case, the report server in all AOS needs to be pointed to and updated to the new location.
- Environment Refresh : Once we restore the production environment to the test environment, we need to adjust the report server configuration to point to the appropriate report server.
Next, follow Reinhard To configure the report server.
- Below we enter System administration>setup>business intelligence>reporting services>report Servers.
- Set the configuration ID to msdynaxmssqlserver.
- Set Description to msdynaxmssqlserver.
- Set the server name as the host name for the report server. My Host Name here is Msdynax.
- Set the server Instance name to the instance name of the report server. The default installed instance name is MSSQLSERVER.
- Set the report Manager URL field to the address set in the SSRS configuration. The default address is http://Host name/reports. My address here is http://MSDynAX/Reports .
- Set the Web Service URL field to the address set in the SSRS configuration. The default address is http://Host name/reportserver. My address here is http://MSDynAX/ReportServer.
- If you are installing SSRSin SharePoint Integrated mode , you must select SharePoint Integrated modehere.
- The default report Folder is dynamicsax.
- Set the application Object Server field to the name of the current AOS . I am here [email protected].
- Finally click Validate Settingsto verify the configuration.
Dynamics AX R2 Configuring a report Server
