What’s working SQL Server 2008 Reporting Services already connected to the customer's data sources and working through the primary Report Developer tool – Report Designer. Report Designer is part of the BI Development Studio (BIDS) that provides the consistent interface across Integration Services, Analysis Services and Reporting Services. 1. Able to deploy the reports from MSVisual Studio 2008 to shared folder 2. View the report in Share point web site 3. The ports of the reporting services and sharepoint are different sharepoint 42771 and reporting services 8888. 4. Authentication is Windows Authentication 5. NT Authority/Network Service has been given priviledges to run the reports, accessadmin We can navigate to Report Server URL OK to display subfolder tree. Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.0 (Build 6002: Service Pack 2) Share Point Integrated Mode Implementation What’s not working SQL Server 2008 Reporting Services also has a component called Report Builder 2.0. Currently we cannot connect Report Builder to the server where the reports will be published. We believe it is a security / permissions issue. Current Process To Generate Error Message 1. Login to the Sharepoint Site 2. Click on Shared Documents 3. Click on the report to view the report 4. Use report tool bar to view the report in report builder 2.0 5. The report builder if not available downloads from the server and installs. 6. The Report Builder 2.0 interface appears but none of the datasource appear. 7. Attempting create a new data source tries to connect to the report server. 8. Connection Failed. Unable to connect to the server that is specified in the URL, http://alpha:8888/RS/reportserver/ Make sure that the server is running, the URL is correct, and you have permission to use this server. Report Builder insatlled in the client PC 1. Start Report Builder 2.0 2. File > Options > Report Builder Options Dialog > Settings tab > Use this report server ... http://alpha:8888/RS /reportserver/ 3. OK 4. Starts to connect , Connect to Report Server message box diplays 5. Fails to connect , with error message box text as follows 6. Connection Failed. Unable to connect to the server that is specified in the URL, http://alpha:8888/RS/reportserver/ Make sure that the server is running, the URL is correct, and you have permission to use this server. Envrionment Server Operating System: Windows Server 2008 Client Operating System: Windows 7.0 Home Premium /reportserver/ 3. OK 4. Starts to connect , Connect to Report Server message box diplays 5. Fails to connect , with error message box text as follows 6. Connection Failed. Unable to connect to the server that is specified in the URL, http://alpha:8888/RS/reportserver/ Make sure that the server is running, the URL is correct, and you have permission to use this server. Envrionment Server Operating System: Windows Server 2008 Client Operating System: Windows 7.0 Home Premium The issue has been long pending please help! ---- MadhuMadhu

5. Fails to connect , with error message box text as follows 6. Connection Failed. Unable to connect to the server that is specified in the URL, http://alpha:8888/RS/reportserver/ Make sure that the server is running, the URL is correct, and you have permission to use this server. Envrionment Server Operating System: Windows Server 2008 Client Operating System: Windows 7.0 Home Premium /reportserver/ It seems the URL is not correct. Could you try this one: http://alpha:8888/RS When publishing to a report server running in SharePoint integrated mode, use a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used (for example, http://servername, http://servername/site: http://msdn.microsoft.com/en-us/library/ms155802.aspx You can also check report project property to ensure if the URL is correct. Hope this helps, Raymond Raymond Li - MSFT

Hi Raymond, I have tried to provide report builder with this http://alpha:8888/RS URL. I also tried to connect to the sharepoint deploy folder url. http://papa/vmrb/reams/nt/ar/Shared%20Documents. The error remains the same. Thank you, MadhuMadhu

Hi, is there anyone who can help on above issue.....its extremely frustrating. thank you, Madhu

Sorry, I didn’t receive any alert email until now. How did you deploy the reports to the server? If you are using BIDS, could you open report project, to copy the TargetServerURL. If not, could you give another try with BIDS to check if there is any permission error (I think the error message from BIDS contains more details information). Hope this helps, RaymondRaymond Li - MSFT

Hi Raymond, I did use BIDS to deploy the reports to the sharepoint shared documents using the URL : http://alpha:42771/sites/sandbox/shared%20Documents http://alpha:42771/sites/sandbox/shared%20Documents http://alpha:42771/sites/sandbox I am able to run the reports on the sharepoint web application which has been deployed from BIDS. when i tried with the report server the below error appears. TITLE: Microsoft Report Designer ------------------------------ Could not connect to the report server http://alpha:8080/TMRS. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server. ------------------------------ ADDITIONAL INFORMATION: System.Web.Services.Protocols.SoapException: This operation is not supported on a report server that is configured to run in SharePoint integrated mode. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedSharePointModeException: This operation is not supported on a report server that is configured to run in SharePoint integrated mode. at Microsoft.ReportingServices.WebServer.WebServiceHelper.EnsureRSNativeMode() at Microsoft.ReportingServices.WebServer.ReportingService2005..ctor() (System.Web.Services) ------------------------------ BUTTONS: OK ------------------------------ thank you Madhu

There are so many URLs in your post. http://alpha:8888/RS/reportserver/ http://papa/vmrb/reams/nt/ar/Shared%20Documents http://alpha:42771/sites/sandbox http://alpha:8080/TMRS Especially for the last one ‘http://alpha:8080/TMRS’, how many report servers do you have? Since you deploy the reports for alpha:42771 then why you set the URL as alpha:8080? Anyway, the only issue is that you cannot connect to Report server (works fine in your sharePoint site) via Report Builder, right? If you can ensure the deployment in BIDS works fine: http://alpha:42771/sites/sandbox/shared%20Documents http://alpha:42771/sites/sandbox/shared%20Documents http://alpha:42771/sites/sandbox Then you should set the same URL http://alpha:42771/sites/sandbox for the Report Builder. IN Report Builder, click Files Button, and then click Options, set the Report server URL as: http://alpha:42771/sites/sandbox You just need to keep the URL in Report Builder same as in BIDS. Hope this helps, RaymondRaymond Li - MSFT

Sorry for the confusion allow me to explain. The uploaded reports which are currently working are in the below folders which is the sharepoint site. http://alpha:42771/sites/sandbox/shared%20Documents http://alpha:42771/sites/sandbox/shared%20Documents http://alpha:42771/sites/sandbox I have set the report server on port 8080 so the report server reads as http://alpha:8080/TMRS. thank you, Madhu

Hi, On providing the Sharepoint URL the report builder 2.0 works but the problem is that i need to provide SQL authentication and does not accept windows authentication. with regards,Madhu

On providing the Sharepoint URL the report builder 2.0 works but the problem is that i need to provide SQL authentication and does not accept windows authentication. You want to use SQL authentication to access SharePoint site? Or you want to create an embedded datasouce in Report Builder? If the datasource type is SQL, then you can use the SQL authentication. If you want to use the shared data source (SharePoint site) in ReportBuilder, then you can only change the authentication in sharePoint site. Change it to a SQL account with password. Hope this helps, RaymondRaymond Li - MSFT

thanks a lot raymond. atlast its done.Madhu

I have the same issues with the inability to connect to the ReportServer from Report Builder 2.0 and I still cannot connect. using win 2008 r2 server sql server 2008 Sharepoint 2010 any ideas?Karen Branson