Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sharepoint integrated reporting deployment problem Expand / Collapse
Author
Message
Posted Monday, November 4, 2013 9:31 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:34 AM
Points: 453, Visits: 570
SQL 2012
Sharepoint 2010
VS / BIDS 2010
using Integrated mode for SSRS with SharePoint report server url is
http://XXXdev002/sites/Reports/_vti_bin/ReportServer/
reports folder is at
http://XXXdev002/sites/Reports/myreports

so in the project properties dialog
the target report server url = http://XXXdev002/sites/Reports/_vti_bin/ReportServer
target report folder = /myreports
I get

Error 1 The path of the item '/sites/Reports/_vti_bin/ReportServer/myreports' 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. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item '/sites/Reports/_vti_bin/ReportServer/myreports 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. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

i have tried many different variations of the report folder name and get the same error. All suggestions gratefully received.
all accounts have full permissions
Post #1511173
Posted Monday, November 4, 2013 7:51 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:26 PM
Points: 2,926, Visits: 2,529
Try using:
target server URL : http://XXXdev002/sites/Reports
target report folder: http://XXXdev002/sites/Reports/myreports

You don't need the "vti_bin" stuff



Post #1511347
Posted Tuesday, November 5, 2013 2:22 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:34 AM
Points: 453, Visits: 570
but when i try that approach i get the following

Error 1 The specified folder is not valid. Specify a value for the TargetReportItemFolder property in the deployment settings. If you are deploying to a SharePoint site, the location must be a fully-qualified URL to the target library or folder. 0 0

Integrating with sharepoint seems to bring in multiple points of failure in the configuration process, when it works its great but if you make a mistake in the set up and configuration its not always noticable until later.

I read an article about disabling anonymous authentication but according to sharepoint that has already been done.
Post #1511401
Posted Tuesday, November 5, 2013 7:39 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 486, Visits: 1,212
Have you enabled MyReports in SSRS ? It is disabled by default.


Post #1511491
Posted Tuesday, November 5, 2013 5:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 23, 2014 12:26 PM
Points: 10, Visits: 57
This may be a rookie question ... but how do you do that ?
Post #1511677
Posted Wednesday, November 6, 2013 6:17 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 486, Visits: 1,212
Connect to Reporting Services using Management Studio. Then right click on server name for Properties. You will see a check box to enable My Reports.


Post #1511847
Posted Wednesday, November 6, 2013 7:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:34 AM
Points: 453, Visits: 570
SSRS isnt running as only the sharepoint integrated service has been installed and configured
Post #1511876
Posted Wednesday, November 6, 2013 8:00 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 486, Visits: 1,212
Oh - sorry I guess that is only for native mode. I did see a post that said that MyReports is not an available feature in SQL 2008 R2 integrated mode. I could not find anything out about that re: SQL 2012.

I know I struggled getting integrated mode to work in our SP 2010 farm with SQL 2008R2. We had a consultant set up the farm but they didn't set up reporting. That fell into my lap, even though I was out of the loop during the initial install. It was a couple weeks of misery, lots of Googling, etc. It doesn't look like it has gotten any better with SQL 2012. All the stars have to be aligned for the thing to work. Good luck. Sorry I can't be of more help.



Post #1511893
Posted Wednesday, November 6, 2013 8:10 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:34 AM
Points: 453, Visits: 570
I know your pain, did the same thing with 2008 in my last company then moved it to 2012 - got everything working lovely then moved. we now have vendor installed reporting solution I'm struggling to se how they got it in this state I cant do a complete rebuild from scratch cos its not my product :-(
Post #1511898
Posted Friday, November 8, 2013 4:30 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:34 AM
Points: 453, Visits: 570
target server URL : http://XXXdev002/sites/Reports
target report folder: http://XXXdev002/sites/Reports/myreports
works but only if you set the other parts you are not using to blank
so as I am not using shared datasets folder or a shared report parts folder if i remove the default setting for them I can deployreports and data connections. other wise it throws errors
following discussion is what led me to a solution

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/09dd0b43-a021-47b0-a943-b58d9e199001/deploy-from-ssdt-formerly-bids-to-sql-server-2012-sharepoint-integrated?forum=sqlreportingservices
Post #1512597
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse