In Microsoft Dynamics GP, when you try to enter the URL for the SQL Reporting Services report server or report manager server, you receive the following error message:
The Target server location entered is not valid
This issue occurs because you did not enter the correct path.
To resolve this issue, follow these steps:
- Start Microsoft Dynamics GP as a user who has access to the
- If you are using Microsoft Dynamics GP 9.0, click the
Tools menu, click Setup, click
System, and then click SQL Reporting Services. If you are using Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 2010, click Microsoft Dynamics GP, click Tools, click Setup, click System and then click Reporting Tools Setup.
- In the Report Server URL box, type the following URL for your version of SQL Server. Replace
ServerName with the name of the server that is running Microsoft SQL Server. Replace PortNumberwith the port number for the Web site that houses SQL Server Reporting Services.For SQL Server 2005
For SQL Server 2008
- In the Report Manager URL box, type the following URL. Replace ServerName with the name of the server that is running Microsoft SQL Server. Replace
ReportsFolder with the name of the folder where the reports are located. Replace PortNumber with the port number for the Web site that houses SQL Server Reporting Services.http://ServerName:PortNumber/Reports/Pages/Folder.aspxNote You can test the URL addresses that you entered in steps 3 and 4 in Microsoft Internet Explorer.