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

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

Thanks Prash, That sorted it. Martin

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

Can you make sure you are using the upgraded Report Designer that ships with SP2? thanx,Prash

That was indeed the problem! After upgrading to SQL SP2 (reporting services included) everything worked fine! Thanx Prash Stefanos

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.

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

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?

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.