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


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

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

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
 

Greetings.

 

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:

1)

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.

2) 

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



View Complete Post


More Related Resource Links

Reporting Services 2008: "HTTP status 401: Unauthorized" Issue

  

I'm getting the error "The request failed with HTTP status 401: Unauthorized" whenever I try to list the reports on my reporting server. The weird thing is, it works when I run the asp.net application on my dev machine hitting the server reporting services web service url (http://www.example.com/reports/reportservice2005.asmx?wsdl) but when the asp.net app is installed on the server (running iis 7) hitting the same url I get the error. Here's my set up:


Server:

SQL Server Reporting services 2008 (not R2)

Web service url: http://www.example.com/reports/reportservice2005.asmx?wsdl


Client

Created a proxy ReportingServices2005.cs

Web.config has <identity impersonate="true"/>

Code to list reports:


<asp:ListView ID="lvReportList" runat="server">
    <LayoutTemplate>
        <ul>
            <asp:PlaceHolder runat="server" ID="itemPlaceholder"></asp:PlaceHolder>
        </ul>
    </LayoutTemplate>
    <ItemTemplate>
        <li>
            <asp:HyperLink runat="server" ID="hpReportLink" NavigateUrl='<%#Eval("Url")%>'><%#Eval("Name")%></asp:HyperLin

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 in SharePoint integration - configurtion errors in 64bit version

  

Hi,

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=9.0.242.0, 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!

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

  
Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Cannot connect to Reporting Services just after installation

  
OS Windows Vista Ultimate. SQL Server 2008 RTM, default instance. Reporting services installed in native mode. Control Panel/Services:Can start/stop Database Engine Instance as well as Reporting Services.============================SQL Server Management Studio:Can connect to Database Engine instanceCannot Connect to Reporting Services Error notification as follows: TITLE: Connect to Server------------------------------ Cannot connect to UNIVERSE. ------------------------------ADDITIONAL INFORMATION: Unable to connect to the server at SERV1. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------BUTTONS: OK------------------------------SQL Server Configuration Manager:Can stop and start instance of Reporting Services   Dump file after starting RS: resourceutilities!WindowsService_0!1024!08/29/2008-14:35:26:: i INFO: Running on 1 physical processors, 2 logical processorsrshost!rshost!1648!08/29/2008-14:35:26:: e ERROR: Failed to regi

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

Configuring Reporting Services Integration with PowerShell

  
I used the powershell script described here to configure my Reporting Services installation through WMI. Now I want to use Powershell to complete the Reporting Services with SharePoint Integration configuration. Is it possible to use PowerShell to perform the steps that you would otherwise do through Central Administration --> General Application Settings --> Reporting Services: Add a Report Server to the Integration Reporting Services Integration I can't find anything that will let me script this part. Can it be done through a PS cmdlet or even wmi? Thanks in advance!

Reporting Services doesn't connect to database automatically

  
Hello. I use Windows 2003 R2 x64 and SQL Server 2005 x64.  The problem is: if the Reporting Services Service were doesn't start automatically, despite the set up parameter "Restart Automatically" every 1 minute in the service Recovery property. So every minute after Service stopped i recieve an error in Event Viewer: Report Server (MSSQLSERVER) cannot connect to the report server database However, after starting it manually from Computer Management->Services or Reporting Services Configuration Tool it starts normally without any error. I use local system admin account to start Services and to connect to Database. Both parameters are set using RS Configuration Tool. Will be thankful for any advice.

Can't connect to SQL Server 2008 Reporting Services

  
When attempting to connect to SQL Server 2008 (evaluation) on Windows XP SP3, using the following url, http://servername:8080/ReportServer I receive a popup dialog box asking me for a user name and password to connect to the server.  When I enter the domain\user and password that I think it should be, it pops up two more times and then displays a blank internet explorer web page.  It is a fresh install and I believe I have everything running correctly.   Any input or guidance would be extremely appreciated.   Thank you in advance.

Cannot connect to Reporting Services

  
I cannot connect to Reporting Services from Management Studio. The error message I get is:   TITLE: Connect to Server ------------------------------   Cannot connect to <SERVERNAME>\ReportServer.   ------------------------------ ADDITIONAL INFORMATION:   Report Server WMI Provider error:   Invalid namespace  (Microsoft.SqlServer.Management.UI.RSClient)   ------------------------------   Invalid namespace  (System.Management)   ------------------------------ BUTTONS:   OK   This appears to be a WMI issue, but when I checked on the SQL server machine, the WMI service is running and the firewall is turned off.   I ran a few tests and found that the WMI has its ReportServer WMI data at \\<SERVERNAME>\root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin:MSReportServer_ConfigurationSetting" (I can find this info using a small console app I had to write). Is this the correct place for the WMI info?   Version info: Microsoft SQL Server Management Studio      10.0.2531.0 Microsoft Analysis Services Client Tools      10.0.1600.22 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 6.0 Microsoft Internet Explorer    &n

reporting services is running but cannot connect

  

Infrastructure people did some maintenance on my SQL Server machine, although I am not sure if that has anything to do with my problem. The problem is, I have the Database Engine and Reporting Services turned on, but I cannot connect to Reporting Services.

Here are the symtoms.

From another client machine, I can connect to the database engine using Mgmt Studio. But using the same server name, I am not able to connect to the reporting services. The error I get back says

TITLE: Connect to Server

------------------------------



Cannot connect to nysrv126,2433.



------------------------------

ADDITIONAL INFORMATION:



The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)



------------------------------

BUTTONS:



OK

------------------------------

"nysrv126,2433" is the server name and it is the same server name I was able to use to connect to the database engine.

 

Next, on the server machine itself, I get the same symtoms as above in Mgmt Studio. That is, I can connect to the database engine but not the reporting services. However, I am able to open up Reporting Services Configuration Manager (which means I connected to reporting services).


unable to connect Reporting Services

  

Hi All,

I have configured Reporting Services in SQL Server 2005 steps.

1) Installed Service pack2 for SQL Server 2005
2) Installed Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft Sharepoint Technologies.
3) From Reporting Services Configuration Manager configured the below list
 -- Report Server Virtual Directory (Configured and icon display green colour )
 -- Report manager Virtual Directory(not configured when i click it shows a message (Report Manger is not     available when the report server is integrated with Windows Sharepoint Services))
 -- Windows Service Identity(Configured and icon display green colour )
 -- Web Service Identity(Configured and icon display green colour )
 -- Database Setup(Configured and icon display green colour )
 -- Sharepoint Integration(Configured and icon display green colour )

4) When iam trying to connect Reporting Services through SQL Server management studio it gives me error
Error:
===================================

Cannot connect to LHI-TEST.

===================================

The operation  is not supported on a report server that is configured to run in SharePoint integrated mode. ---> The operation  is not supported on a report server that is configured to run

SQL Server Reporting Service 2008 R2 - The request failed with HTTP status 401: Unauthorized.

  
I got the error "The request failed with HTTP status 401: Unauthorized." when I call the Reporting Service Web Service.

The code is very simple:

// Initialise the reporting service Web Service

this.RSWebService = new ReportingService2010();

// Pass windos authentication credentials to Web Service

this.RSWebService.Credentials = System.Net.CredentialCache.DefaultCredentials;

// List children

List<CatalogItem> reports = this.RSWebService.ListChildren(folder, false).ToList();

The SQL Server is installed on a different machine (say server A) from the Web server (say server B). We are using Windows Server 2003.

The code work fine for all the scenario below:

i) Run locally (XP) to call the web service on the sql server

ii) Provide the Network Credentials with the username, password, and domain when calling the web service

iii) If the web server and sql server is using same server (i.e. not distributed)

I'm using windows authentication and impersonation. Any idea?


Cannot connect to Reporting Services in SSMS using Servername

  

Hi,

Kindly help me as i can't connect to Reporting Services in SSMS using SERVERNAME but using URL(http://localhost/ReportServer) I can connect. Here is the error I received. Please advice.

TITLE: Connect to Server
------------------------------

Cannot connect to PERRYDUNDOC-W7.

------------------------------
ADDITIONAL INFORMATION:

Unable to connect to the server at SERVERNAME. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------
BUTTONS:

OK
------------------------------

Thanks,
Perry


Does SSL activation in Reporting Services 2005 exclude the use of http in favor of https ?

  

Hello SSRS Community,

I would like to know if the activation of SSL (Secure Socket Layer) allow the use of both HTTP and HTTPS to access the report server

I have been asked by a web developer in my company to check if in SQL Server 2005 reporting services the activation SSL makes it possible to access the Report Server with both HTTP and HTTPS.
For example:
1. Without SSL activation you can use http://ServerName/ReportServer to access your report server
2. Once SSL is activated, we are wondering if it will be possible to access the Report Server with the following two links:
a. https//ServerName:443/ReportServer

Thank you


Seme

Reporting Service Integration, Unable to access Reporting Services Site Settings

  

I am attempting to get reporting services running in integrated mode with sharepoint 2010. I have everything installed and features turned on. In the site collection, when I click on  Site Settings > Reporting Services Site Settings, I am presented with:

Error: The request failed with HTTP status 401: Unauthorized.

 

I get virtually zero hits when searching for this. Any help is appreciated.

 


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