.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 Server 2010: Reporting Services Integration - 401: Unauthorized

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :SharePoint

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

View Complete Post

More Related Resource Links

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 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:

  • SharePoint 2010 & Sql 2008 Reporting Services Integration


    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.

    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!

    Office Services: Merging Word Documents on the Server Side with SharePoint 2010


    Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

    Manvir Singh, Ankush Bhatia

    MSDN Magazine July 2010

    Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration


    The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

    Ed Hild

    MSDN Magazine March 2006

    Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


    I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

    Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

    Any help will be very appreciated!


    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

    HTTP 401: Unauthorized when trying to specify reporting services for integration, cannot connect to




    I am trying to install reporting services and join it into existing service farm.

    Main  MOSS 2007 is on one pc, with config bases etc, while reporting services, reporting services db will be on other pc. 

    We are using same domain account to run sharepoint services and reporting services. 

    I've installed web part of MOSS on that other computer, also reporting services and sql server, set reporting services in integration mode.

    Either way, it wont work for me:


    If i am running the service of reporting services as Network Service account, then the /reportserver page will complain about some generic error "probably you dont have access to the farm if you are in integrated mode" etc.... 

    I've read that i should include networkservice into a group WSS_WPG which i did, no luck anyway, same error

    If i try to type the adress into the integration with reporting services in moss admin page, i will get error like "expected xml received html" and alot of red text.


    If i switch service to run from domain account (the one that is used for running sharepoint on the domain) (we did the spn thing, didnt work either), the /reportserver page will open

    (moss2k7/ReportServer - /

    Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

    Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

    Converting Word Documents to PDF using SharePoint Server 2010 and Word Services (Visual How To)

    Watch the video and explore code as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010.

    Sample: Converting Word Documents to PDF using SharePoint Server 2010 and Word Automation Services

    Explore the code in this visual how-to article as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010.

    Video: Converting Word Documents to PDF Format Using SharePoint Server 2010 and Word Services

    Watch this visual how-to video as you learn how to programmatically convert Word documents to PDF format on the server by using Word Automation Services with SharePoint Server 2010. (Length: 6:15)

    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!

    Creating Custom Business Connectivity Services Connectors Using SharePoint Server 2010

    Learn how to create a Business Connectivity Services (BCS) custom connector to integrate data sources into SharePoint Server 2010.

    Sharepoint 2010 Business Intelligence integration with datasources other than MS SQL Server

    I want to Implement Business Intelligence by SharePoint 2010 on top of data sources other than MS SQL Server or MS Analytics Services ( cubes ), for example Oracle RDBMS and Oracle OLAP ( cube ) or Teradata. Quesiton : Is there any way to do this, if the is, how do I bring metadata to sharepoint BI or how do I make SharePoint BI to see other data source. I've looked at Busines Data Connectivity in Visual Studio, but that is more for two way integration and didn't seem like a good or easy way just to bring new data sources to SharePoint BI I found some tool from third party company "BDC Meta Man" which created metadata layer for Oracle RDBMS in SharePoint, but I thought there must be a way to do it by using Microsoft tools

    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
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