.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SharePoint 2010 & Sql 2008 Reporting Services Integration

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server

Need a little help.  Here is the error message I recieve when trying to add the Reporting Services URL in Central Administration

Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages

Here is the report from the Log.

10/20/2010 14:31:56.58  w3wp.exe (0x0B6C)                        0x05E8 SQL Server Reporting Services  Configuration Pages            aabe Medium   RS configuration object updated with RSServerUrl=http://sql2/ReportServer, AuthenticationType=Windows 58bcdd3b-13e9-4bd7-8008-718e5fd7202a
10/20/2010 14:31:57.61  w3wp.exe (0x0B6C)                        0x05E8 SQL Server Reporting Services  SOAP Client Proxy              0000 High     Exception encountered for SOAP method GetSystemProperties: System.

View Complete Post

More Related Resource Links

SharePoint 2010 and Reporting Services 2008 R2 Integration Fail - Failed to establish connection wit


We have installed SQL Server 2008 R2 Standard Edition on a virtual server (C-SQL) and SharePoint Server 2010 on another virtual server (C-SPOINT), with the SQL Backend of the SharePoint database residing on C-SQL. This worked fine.

SQL Server was installed with the domain administrator account and SharePoint with an account called 'visi' that has domain administrator privileges.

SSRS on C-SQL was initially installed as a native database. I changed this to a SharePoint integrated database with all authentications done as the visi user. Report server url was set to the normal http://C-SQL:80/ReportServer/.

On the SharePoint central administration site under General Application Settings -> Reporting Services Integration I filled in the details as required:

  • Problems with Report Services 2008 Integration in Sharepoint Foundation 2010

    hi Folks, i ihave tried to solve my problem with this entry, but it has not fixed the issue. I would like to integrate RS in a Sharepoint Foundation 2010 environment, but when try to integrate the RS in Central Administration I am receiving the following error, see pic: Central Administration jpg When I try to access direct the RS Url the I get an access denied error please help.   thx a lot

    Windows Sharepoint Foundation 2010 - Document Library Settings with Reporting Services 2008 R2 in in

    I have a client who has recently upgraded their SharePoint system to Windows Sharepoint Foundation 2010 with Reporting Services 2008 R2 in integrated mode. I have configured reporting services and am able to deploy reports to SharePoint. The client created a document library before the upgrade to WSF 2010. I need to add Report Builder 3.0 to the New Document menu and found the following article. http://technet.microsoft.com/en-us/library/bb326289.aspx "Allow management of content types?" is set to yes under the advanced document library settings. The problem is that when I try to "add from existing site content types" the reporting services content types are not in the list. I appreciate any help you can give me.

    Sharepoint Server 2010: Reporting Services Integration - 401: Unauthorized


    Hi everybody,

    I know - there are lot's of articels, posts, etc.. about configuring Reporting Services in Sharepoint 2010 and I feel like I read them all hundred times at least... but none of them helped me solving my problem.


    I have the following Scenario at a customer:

    Servername / Functionality

    db01 / MsSQL 2008 R2 server (also contains the ReportServer DB - of course it's type is Sharepoint Integrated)

    app01 / Sharepoint 2010 Server (Complete Installation) - used as Indexing Server and running some other Service, Central Administration, Reporting Server

    *fe01 / Sharepoint 2010 Server (Complete Installation) - used as Frontend Server

    *fe02 / Sharepoint 2010 Server (Complete Installation) - used as Frontend Server

    *member of Windows NLB


    I configured Reporting Services Integration in Central Admin and everything worked perfectly correct - no errors - strike!.

    But now comes the "funny" part:


    If I open a Report on a Sitecollection like http://app01:1234/ the report is getting rendered and presented - yeah!

    But if I open a Report on a Sitecollection like http://NLB-URL/ the report throws an error (damn!):

    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    Reporting services and Sharepoint Foundation 2010 + SQL Server 2008 R2 RTM - Express with Advanced S



    is possible use reporting services in Sharepoint Foundation 2010 if I have installed SQL Server 2008 R2 RTM - Express with Advanced Services? I tried various settings and configurations, but it not works (I am not able successfully configure Reporting Services Integration in Central Administration).

    Now I am not sure that is possible use reporting services in SPF 2010 + SQL Server 2008 R2 RTM - Express with Advanced Services...

    Thank you!

    Reporting Services 2008 and SharePoint 2010


    I have Reporting Services 2008 and it is not configurate yet, we will buy SharePoint 2010, but we need to begin to work now with Reporting, can I configurate Reporting before SharePoint and when we have SharePoint, I can reconfigurate Reporting? or we can wait for SharePoint



    Reporting Services in SharePoint integration - configurtion errors in 64bit version



    We have build an MOSS 2007 environment on 64 bit servers. We build the reporting services server and configured in SharePoint integration mode. Initially configuration looks fine with reporting services integration with green indicators.


    After creating a web application and accessing the web site from the report servor, i have found the following errors:


    Server Error in '/' Application.

    Configuration Error
    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: Could not load file or assembly 'RSSharePointSoapProxy, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi

    Reporting Services and Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

    I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone: System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. Is this a limitation of the SQLRS-WSS3 integration or is there a workaround? Many thanks to anyone who can help!

    SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

    I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

    SharePoint integration with SQL Server 2005 Reporting Services

    Hello Everyone,   I have been banging my head against the wall with trying to integrate SharePoint 2007 and SQL Reporting Services.  If anyone could offer any assistance, I would appreciate it greatly. I have been following these 2 websites down to the letter in trying to configure everything:     1. http://msdn2.microsoft.com/en-us/library/bb326356.aspx     <---Microsoft's Steps   2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with- wss-3-0-and-moss-2007.aspx   <---SharePoint Blog Group     Basically my setup is as follows:   Server 1 = SharePoint 2007 Server 2 = SQL Server Reporting Services SP2 / SharePoint 2007 services Server 3 = Database   Server1 is setup and running SharePoint 2007 fine with no problems. It was installed under the complete option with its own server farm. Then with the Server2, SharePoint 2007 is installed again, also under the complete complete option, and configured to join Server1's server farm. In this way, Server2 is able to supply Server1 with services and it has been said that if you are using 2 different servers, one for SharePoint and one for Reporting Services, you need to have an instance of SharePoint on the reporting services box. With a SharePoint "front-end" the reporting-services now has a way to also join Server1s farm.   This is where the headache be

    SharePoint 2010 Reporting Services Integrated-mode Error

    I am running SharePoint 2010 and Reporting Services 2008 R2 SharePoint integrated-mode. I am able to browse to the reportserver site : http://DBserver/reportserver which lists my site collections and I am able to get to the document library which holds my reports. However, when I try opening a report I get the following error: Report Server has encountered a SharePoint error. (rsSharePointError) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. For more information about this error navigate to the report server on the local server machine, or enable remote errors I am able to resolve that issue by going to Central Admin, Application Management, General Settings and turning Web Page Security Validation Off. But if I do that I get an error when using silverlight features like site, or list creation. Any ideas?

    Changing a current SQL 2008 Express Sharepoint instance to incl. Reporting services

    I have a current instance of SQL 2008 Express that was created with a Sharepoint installation. Currently, that is the only purpose of the instance. We don't have management studio installed but from what we can tell by searching help screens is that instance is on SP 1 (10.1.2531.0) with Database Engine Services and SQL Server Replication. We need to now add Reporting Services. If we go to the Installation Tools to Add/Change the current instance, it asks for the SQL media which was from the original Sharepoint install. I have downloaded SQL 2008 Express with Advanced Tools but not SP 1. I've seen some threads where this wasn't a direct install. Ideally, I'd like to be able to change the current instance to add Reporting Services. When the wizard prompts for the media, will I be able to now point to the downloaed SQL Express w/ Adv. Tools even if it's not SP1? Thanks for your help. Tracy

    Reporting Services 2008 report integration in a gadget


    Hello everybody,

    I would like to distribute a small report I have made in Reporting Services which contains only one graph by using a Windows 7 Gadget. Does anybody know how to integrate a MS SQL Reporting Services 2008-report in a gadget?

    Your answers are greatly apreciated.


    Kind regards,


    Rendering Reports in Reporting Services 2008 in Sharepoint Integrated Mode


    I have created a site collection using the Report Center template. I successfully deployed my VS2008 Reporting Servivces project to the Sharepoint site. However, when I goto the reports library and attempt to run a report I get "unknown error" message"

    Also, I can create a dashboard consisting of one of my reports. However, when I attempt to view the reports via the dashboard, I get the following error message:

    An error occurred during client rendering.

    The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it.

    SSRS 2008 R2 running in SharePoint 2010 Integration mode - Not able to schedule reports.



    I am unable to schedule report am getting following error when trying to schedule an SSRS report from ReportViewer Webpart in SharePoint 2010.

    • The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)

    I have SSRS 2008 R2 running in SharePoint 2010 Integration mode on Win 2008 R2 System.

    I have also setup the unattended execution account from the Reporting Services Configuration Manager, which has appropriate privilates on the database to generate report.

    Also, I have reporting webservice setup @ following url (am using the named instance of SQL Server):


    Am able to view the report from report viewer webpart but unable to schedule it.

    Kindly let me know what's going wrong.

    Thanks in Advance,

    Sachin R. Chavan.

    Sachin R. Chavan.

    SQL 2008 R2 Reporting Service SharePoint 2010 Add-in Installation problem - Interrupted


    WIN SERVER 2008


                                        http://myserverdomain/reportserver -- I can see my subsite, and at footer it shows SQL SERVER Reporting Services Version

    Sharepoint 2010   ---  Installed, before I install Sharepoint 2010, I run the "Install Software Prerequisites", since my server doesn't have Internet connection, I manually download all those components(hot fix KB976462, Filter Pack 2.0, etc.) and then copy to server then do the installation.

    I am trying to install the 'Reporting Services Add-In for SharePoint'.  (downloaded rsSharepoint_x64.msi), its rolling back the installation at the last step and showing me the message saying"Please Ensure Microsoft Sharepoint technologies is installed".



    Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


    how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


    Thanks in advance

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend