Error message in Microsoft Dynamics GP when you try to enter the URL for the SQL Reporting Services report server or report manager server: "The target server location entered is not valid"

Symptoms

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

Cause

This issue occurs because you did not enter the correct path.

Resolution

To resolve this issue, follow these steps:

  1. Start Microsoft Dynamics GP as a user who has access to the
    System menu.

  2. 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.

  3. 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
    http://ServerName:PortNumber/reportserver/reportservice.asmx

    For SQL Server 2008
    http://ServerName:PortNumber/reportserver/reportservice2005.asmx

  4. 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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×