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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Reporting Service Integration, Unable to access Reporting Services Site Settings

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

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.

 




View Complete Post


More Related Resource Links

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

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

  

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

No Access to Reporting Services Manager Website

  
Hi, I am trying to  access the report manager website with http://localhost:8080/Reports. I know that this was working in the past with the Administrator user. Now I get the login Form repeatedly and I have no access with any user. With the administrator user I can access the reporting services in Management Studio but not the website. Please 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

Windows service can't use Reporting Services on SQL Service 2008 R2

  
Hello. I have a Windows service that run as Local System account. The service uses the Reporting Services ReportService2005.asmx web service. When I have SQL Server 2008 installed, I have no problems and my service is able to browse and create report. After I have installed SQL Server 2008 R2 I get the error "The request failed with HTTP status 401: Unauthorized." when the service tries to use the web service. If I change my service to log on as a user with administrator rights, it is able to use Reposting Services again. What has changes in SQL Server 2008 R2, that doesn't allow the Local System account to use Repoting Services? And is it possible to configure Reporting Services to allow it?   - Per

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Reporting Services 2008 - Anonymous Access

  
Hello,   In SSRS 2005 I was able to grant anonymous access to my reports by changing the authentication mode for the Reporting Services virtual directory in IIS to Anonymous and then adding the 'account used for anonymous access' to the permissions on the appropriate Reporting Services directories (in report manager).   Now with SSRS 2008 there are no virtual directories in IIS.   I tried to follow the instructions given:   http://technet.microsoft.com/en-us/library/cc281310.aspx (Authentication Types in Reporting Services)   Which instructed me to use the custom AuthenticationType, and following the instructions here:   http://technet.microsoft.com/en-us/library/cc281383.aspx (How to: Configure Custom or Forms Authentication in Reporting Services)   which just got me an error: The Authentication Extension threw an unexpected exception or returned a value that is not valid: . (rsAuthenticationExtensionError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors   Any ideas on how to set up anonymous access to SSRS2008?   Thanks for any time and help!   -Tim

SharePoint and SQL reporting services. Report of access?

  
Hello,Can a report be created with SharePoint and SQL reporting services that shows who has accessed the document and when?Thanks in advanceSebastian  

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

Access from Reporting Service database in Sqlserver2005 to Sqlserver2008 R2 database

  
We are going to upgrade our databases from SQLServer 2005 to SQLServer 2008 R2. Today the databases including Reporting Services are running in SQLServer 2005 9.0.4211 and in a cluster environment. We are planning not to upgrade the Reporting Service database to Sqlserver 2008 R2. The Sqlserver2005 and Sqlserver2008 R2 will be run side-by-side.   My question is: Is it possible to access a database running in Sqlserver 2008 R2 from a Reporting service database that is running in Sqlserver 2005 (9.0.4211)?  

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!

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.

Unable to initialize reporting service after installing SP2

  
hi, I have problem initialize report server after upgrade to SP2.. It keep saying Could not locate entry i sysdatabases 'myDatabaseName'. while i'm sure my database existing. Here's the log   <Header>  <Product>Microsoft SQL Server Reporting Services Version 9.00.3161.00</Product>  <Locale>en-US</Locale>  <TimeZone>Malay Peninsula Standard Time</TimeZone>  <Path>C:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerService__07_12_2007_11_38_15.log</Path>  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>  <OSVersion>5.2.3790.65536</OSVersion></Header>ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing PollingInterval to '10' second(s) as specified in C

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

Can't install Service Pack 3 for SQL Server 2005 Reporting Services

  

I just installed a stand-alone SQL Server 2005 reporting services on a 64-bit Server 2008 machine without receiving any errors.  I have not configured reporting services yet, but I'd like to patch it with Service pack 3. However, when I execute Service Pack 3, it won't let me check the box for reporting services.  I've rebooted, etc.  The database is not installed on this server, just reporting services.

I have performed many searches, but I have not seen anyone with a similar problem.  What can I do so that it allows me to check the box during service pack installation?

--Max


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