Learn how to a build a cloud-first strategyRegister Now


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
Medium Priority
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

adimit earned 0 total points
ID: 22897013

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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

810 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