Deploy/edit reports in sharepoint integrated mode
Hi, I'm working with the Dec CTP of SQL 2005 SP2 and the associated Sharepoint addin. I've been able to get a report created in VS2005 and manually uploaded to the Document Library holding reports, and the report works when I open it (using an internal datasource, not shared). My first problem is I can't get VS2005 to deploy datasources or reports to my doc library.I have configured TargetDataSourceFolder http://server/site/doclibTargetReportFolder http://server/site/doclibTargetServerURL http://server/ When I try to deploy my Shared Data Source, it asks me to login, and will not accept my credentials (I am farm administrator, and site collection administrator, and local administrator, and a site owner) Secondly, for the report I manually uploaded, I can't edit it in Report Builder (from Sharepoint) because I get stuck on entering something that works into the Select Site or Server dialog box. I've tried http://server/ and http://server/site/ and http://server/site/doclib Can I have some tips please? ThanksMartin
January 26th, 2007 5:57pm

If you see a login screen when deploying then inspect the web.config file of the SharePoint web site for the following entry: <location path="_vti_bin/ReportServer/ReportServiceAuthentication.asmx"> <system.web> <authorization> <allow users="*" /> </authorization> </system.web> </location>Make sure there is only one such entry in the web.config file. Delete any duplicates. Next retry deploying. This is a know issue in the CTP release that we are fixing for RTM. This should also get you past the Select Site or Server dialog box in ReportBuilder . Hope this helps. thanx,Prash
Free Windows Admin Tool Kit Click here and download it now
January 27th, 2007 1:51am

Thanks Prash, That sorted it. Martin
January 29th, 2007 4:53pm

Hi! I've been trying to deploy reports from Visual Studio to my SharePoint 3.0 site. I have configured : TargetDataSourceFolder http://server/site/doclibTargetReportFolder http://server/site/doclibTargetServerURL http://server/reportserver but deployment fails, with the message "Error 23: The operation is not supported on a report server that is configured to run in SharePoint integrated mode." Note that my ReportServer works fine, so do the manually uploaded reports and datasources. Any ideas? PS. Is there any other way of (massively) deploying reports to a WSS 3.0 site? Not just uploading them, but also connecting them with the datasource. Thanx in advance Stefanos
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2007 4:51pm

Can you make sure you are using the upgraded Report Designer that ships with SP2? thanx,Prash
March 1st, 2007 10:49am

That was indeed the problem! After upgrading to SQL SP2 (reporting services included) everything worked fine! Thanx Prash Stefanos
Free Windows Admin Tool Kit Click here and download it now
March 1st, 2007 11:26am

I'm having this same issue. I've updated my client with sql2005 sp2 and noticed differences in the message.. it now shows up in a dialog box, but I still continue to get the error. I don't see a web config in my ssrs project.. but I do notice it I try to deploy to that URL I do get prompted for security.. but no user/password seems to work. Something different about my configuration..and everything does appear to be in working order, but i navigate to http://myssrsserver/reportserver I just get .. n o menu as expected. myssrsserver/ReportServer - / Microsoft SQL Server Reporting Services Version 9.00.3042.00 If I navigate to http://myssrsserver/reports I get: The operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode) Get Online Help Get Online Help Thanks for any help information.
September 17th, 2008 7:35pm

To clarify the web.config mentioned in this thread is that of the SharePoint site. Do you see duplicate entries for the following entry in yourweb.config file for the SharePoint web site you are dpeloying to: <location path="_vti_bin/ReportServer/ReportServiceAuthentication.asmx"> <system.web> <authorization> <allow users="*" /> </authorization> </system.web> </location>Additionally, what happens when you browse toReportServiceAuthentication.asmx endpoint on the TargetserverURL you are deploying to, as follows: http://<TargetServerURL>/_vti_bin/ReportServer/ReportServiceAuthentication.asmx ? thanx, Prash
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2008 8:07am

For SSRS 2008 - I get:Semantic Model Designer A connection could not be made to the report serverWhen trying to deploy my report model via BIDS 2008.Does anybody have any ideas how to fix it?
January 6th, 2010 6:30pm

Hi Prash, That's really useful. I'm seeing the same issue (I can upload reports manually, but I can't deploy them), but instead of duplicates I am missing that config entry entirely. Navigating to <TargetServerURL>/_vti_bin/ReportServer/ReportServiceAuthentication.asmx works fine. Is it safe to just add that config entry on its own, or do I need to do something more sophisticated? Thanks, Beth *edit* if it's relevant, I'm using Sharepoint 2010, and SSRS 2008 R2.
Free Windows Admin Tool Kit Click here and download it now
February 4th, 2011 7:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics