Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Sharepoint integrated reporting deployment problem


Sharepoint integrated reporting deployment problem

Author
Message
Martin Stephenson
Martin Stephenson
SSC-Addicted
SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)

Group: General Forum Members
Points: 459 Visits: 679
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
happycat59
happycat59
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3566 Visits: 3110
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



Martin Stephenson
Martin Stephenson
SSC-Addicted
SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)

Group: General Forum Members
Points: 459 Visits: 679
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.
Ed Zann
Ed Zann
Mr or Mrs. 500
Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)

Group: General Forum Members
Points: 507 Visits: 1391
Have you enabled MyReports in SSRS ? It is disabled by default.



coreyjbaum
coreyjbaum
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 264
This may be a rookie question ... but how do you do that ?
Ed Zann
Ed Zann
Mr or Mrs. 500
Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)

Group: General Forum Members
Points: 507 Visits: 1391
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.



Martin Stephenson
Martin Stephenson
SSC-Addicted
SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)

Group: General Forum Members
Points: 459 Visits: 679
SSRS isnt running as only the sharepoint integrated service has been installed and configured
Ed Zann
Ed Zann
Mr or Mrs. 500
Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)

Group: General Forum Members
Points: 507 Visits: 1391
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.



Martin Stephenson
Martin Stephenson
SSC-Addicted
SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)

Group: General Forum Members
Points: 459 Visits: 679
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 :-(
Martin Stephenson
Martin Stephenson
SSC-Addicted
SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)

Group: General Forum Members
Points: 459 Visits: 679
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search