Report Model (SQL Server 2005 sp2) deployment to sharepoint 3.0 sp1- Error: the path of the item '/DataSources/ReportServer' is not valid.

Posted on 2008-11-06
Last Modified: 2009-07-29

When I deploy a report model using visual studio I get the following error:

The path of the item '/DataSources/ReportServer' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with a slash.

What path is the message referring to? Where do I go change this path?

The Visual Studio being used comes with sql server 2005 sp2. The sharepoint server, database, and reporting services server are all on the same machine. The computer is not a domain controller
Question by:adimit
    1 Comment

    Accepted Solution


    From the project menu select report model project properties

    Default Target Data Source Folder: http://iishostname/Sharepointsitename/Data Sources
    Default Target Model Folder: http://iishostname/Sharepointsitename/models

    where Sharepoint sitename was created from the sharepoint administration window
    and iishostname is the webserver name

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now