how to deploy shared datasources to Sharepoint?
Hi!
Im having an issue loading my SSRS reports onto Sharepoint 2010. Its set up in SP integrated mode and I have a site set up
http://<servername>/sites/Information
I am able to load ssrs (2008 r2) reports on if the datasources are embedded. These work fine. (im deploying from BIDS)
but when I try to deploy a shared datasource, the report fails
with the following error message:
Error
1
The path of the item '/http://<servername>/sites/Information/data connections' 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 slash.
my deployment properties are:
targetDataSourceFolder /http://<servername>/sites/Information/data connections
TargetServerURL
http://<servername>/ReportServer_SPSSRS87
Can anyone help?
Cheers,
Zoe
Reply
Quote
September 7th, 2012 8:24am
Is that the exact value from the target data source folder? if so is it the slash in the beginning maybe?
DWM
Free Windows Admin Tool Kit Click here and download it now
September 7th, 2012 10:52am
The other thing is that you may have to format the URL for the data sources as follows to include the space indicator:
<a href="http:///sites/information/data%20connections">http://<servername>/sites/information/data%20connectionsDWM
September 7th, 2012 11:14am
Hi Zoe,
From your description, it looks like TargetServerURL is invalid. When publishing to a report server running in SharePoint integrated mode, we use a URL to a SharePoint top-level site or sub-site.
You can modify the TargetServerURL to http://<servername> or http://<servername>/sites/Information.
Reference:
How to: Set Deployment Properties (Reporting Services)
Regards,
James
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
September 12th, 2012 1:56am
Hi Zoe,
From your description, it looks like TargetServerURL is invalid. When publishing to a report server running in SharePoint integrated mode, we use a URL to a SharePoint top-level site or sub-site.
You can modify the TargetServerURL to http://<servername> or http://<servername>/sites/Information.
Reference:
How to: Set Deployment Properties (Reporting Services)
Regards,
James
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
September 12th, 2012 1:56am