Resources for IT Professionals > Dynamics Forums > GP > Dynamics 10, SQL Server 2005, Trying to be able to edit and author SRS Reports on the remote server
Ask a questionAsk a question
 

QuestionDynamics 10, SQL Server 2005, Trying to be able to edit and author SRS Reports on the remote server

  • Friday, June 26, 2009 6:15 PMJoseph Lovegren Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I have full capability to edit an author new report serer objects on the server itself but I am having trouble getting the same capability on my client notebook.

    I am trying to run the MS SQL Server Reporting Services Wizard (from the business intelligence folder in my MS Dynamics Program Group)

    Page 1:
    Name of the MS Dynamics GP Server:  I use the real name
    SQL Log on credentials:  sa & the sa password

    Page 2:
    Selece the Database to deploy reports for:  I am able to pull up a list of all databases, I choose my live database
    Modules:  I choose "Select All"

    Page 3:
    Target Server URL:  http://ssp/reportserver

    X Failed to map the path '/reportserver'
    ---------------------------------------------

    If I use the fully qualified name, same error.
    If I remove "reportserver" I get "Client response content type of 'text/html', but expected 'text/xml'

    -----------------------------------------------
    When I go to the SQL server itself and check the configuration properties
    Deployment-
    OverwriteDataSources: False
    TargetDataSourceFolder: Data Sources
    TargetReportFoder: Custom
    TargetServerURL: http://ssp/reportserver


    I CAN'T FIGURE OUT HOW TO GET THS SETUP, IT IS DRIVING ME NUTS.
    Any ideas??

All Replies

  • Friday, June 26, 2009 6:36 PMScott Sewell, CustomerEffectiveMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I think you intended this to be posted to a GP forum - I'm moving it for you.
    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell