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


Post New Web Links

The operation is not supported on a report server that is configured to run in Sharepoint Integratio

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server
 

The operation is not supported on a report server that is configured to run in Sharepoint Integration Mode

I am getting the above error while i am connecting to the Report Server through SQL Server Management Studio Server Type:Reporting Services.

How can i overcome the above error.

 

Thanks

TSQL


Ramesh.M


View Complete Post


More Related Resource Links

The Operation is not supported on a report server that is configured to run in sharepoint integrated

  

Hi All,

I have installed and Configured SQL Server reporting services 2005. i can able to connect to report server through web http://localhost/reportserver but unable to connect to reporting services through SQL Server management studio. it gives me below error.

Error: cannot connect to xyz server
Additional information: The Operation is not supported on a report server that is configured to run in sharepoint integrated mode.(Microsoft.SqlServer.Management.UI.RSClient)

i have also checked the rsreportserver.config file <UrlRoot>http://localhost:3000/reportserver</UrlRoot> is configured correctly.

Please help me.
Thanks in advance.


My report manager url getting error (Error:This operation is not supported on a report server that i

  

Hello Friends,

 I am MD.Liakath ali new to sharepoint  , I need Report Server as fine without errors,  bcz after installatino My Report manager URL getting error. I want to genrate a report based on 2 or more list columns in sharepoint 2010 in report server.

For reporting config manager i installed like as bellow:

1. At the time SharePoint 2010 installation in standalone server"Reporting Services Feature is in Native Mode".
2. Add-In s/w installed and configured with rsCustomAction.exe /i this cmd,
3. Enabeled TCP/IP in SQL server config manager "MSSQLSERVER TCP/IP Enabled"
4. I opened Reporting Services Config Mannager as administrator:
                      In service a/c: Selcted 'Network Service',
                      Created Database in sharepoint integrated mode,
                      Local Instance of sql server Authentication Type: Current Integrated se

Verify Report Server is configured in SharePoint Integarted Mode

  
There is no Web named "/sites/AGA/Reports/Forms/AllItems.aspx".	 
Possible mismatch between the reported error with code = 0x81070504 and message: "There is no Web named "/sites/AGA/Reports/Forms/AllItems.aspx"." and the returned error with code 0x80070002.	 
Potentially excessive number of SPRequest objects (15) currently unreleased on thread 7. 
Ensure that this object or its parent (such as an SPWeb or SPSite) is being properly disposed. 
Allocation Id for this object: {541593A7-D430-43BE-BA21-12BE66844098} Stack trace of current allocation:  
at Microsoft.SharePoint.SPRequestManager.Add(SPRequest request, Boolean shareable)   
at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)   
at Microsoft.SharePoint.SPWeb.InitializeSPRequest()   
at Microsoft.SharePoint.SPWeb.EnsureSPRequest()   
at Microsoft.SharePoint.SPWeb.get_Request()   
at Microsoft.SharePoint.SPWeb.InitWebPublic()   
at Microsoft.SharePoint.SPWeb.get_Exists()   
at Microsoft.SharePoint.Publishing.CachedObjectFactory.CreateWebFromUrl(String url)   
at Microsoft.SharePoint.Publishing.Navigation.SPNavigationSiteMapNode..ctor(PortalWebSiteMapNode webNode, SPNavigationN

Verify that the report server is available and configured for SharePoint integrated mode

  

Hi,

I have sharepoint and ssrs on the same computer. I have reporting service setup in intergration mode. I've also set sharepoint up to use the report server DB. This all appear to be well and good. When I try to either deploy a report in ssrs, or upload a reports and view it in sharepoint i recieve the following error:

 

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with the error message: 
-- 
<html><head><title>Object moved</title></head><body> 
<h2>Object moved to <a href="http://derdtp9592:81/_layouts/1033/error.aspx?ErrorText=Failed%20to%20Execute%20URL%2E">here</a>.</h2> 
</body></html> 

Cannot export from a Report in SharePoint integrated mode in a server hardend environment

  

We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.

 

We can only assume that this issue has something to do with server hardening/UAC as we have

Video: Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services

  
Watch this visual how-to video as you learn to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0. (Length: 7:56)

Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services 3.0 (V

  
Watch the video and explore code as you learn how to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0.

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

  
Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

SharePoint - Report Server - Client Certificate authentication

  
Hi,I have a SharePoint site collection which requires client certificates. On the server I have configured Reporting Services in integration mode.I can call reports on other site collections which don't require client certificates but not on the site which does. On the site which requires client certificates the pages fail with the following error message:'An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 403: forbidden'The error message indicates that SharePoint doesn't call the web service with a client certificate. Does anyone know how I can configure SharePoint to use a client certificate?Any help is greatly appreciated.Adam

The report server instance is not configured correctly. Please use the Reporting Services Configurat

  
Hello All, I am having problem in configuring report server in SharePoint 2010 Central Administration. The Scenario is explained below: We have farm with two Servers with following components installed: 1. APPSERVER : SharePoint 2010, SSRS(2008 R2) and Reporting Services Add in (installed using credentials    (domain/sharepointuser)) 2.  SQLSERVER: SQL SERVER 2008 R2, Report Server Database (installed using credentials    (domain/sqluser)) Steps followed: a. Configured Report Server on APPSERVER with database in SQL SERVER. We browsed the report server url (http://localhost/reportserver) successfully b. Installed Reporting Services Addin on APPSERVER c. In SharePoint Central Administration, Under Reporting Services Integration, we gave the report server web server url as http://localhost/reportserver , authentication as Windows Authentication and credentials which are used to install SQL SERVER (domain/sqluser) d. We also added a new group called WSS_WPG Error is given below: The report server instance is not configured correctly. Please use the Reporting Services Configuration tool to create a report server database in SharePoint integrated mode before setting integration options for this SharePoint Web application. Thanks in Advance  

Is it possible to configure sharepoint to use active directory service configured in another server

  
I installed sharepoint in a computer which is not configured as a domain,I want it to use the active directory services in the domain which is another computer

Sharepoint 2010 & Report Server Web part

  

Hello all,

I'm doing some test integrating Sharepoint 2010 with Reporting Services.

My farm (a single server installation) is :
Sql Server 2008 R2
Sharepoint 2010 Enterprise

I've correctly set up the integration and all is working fine with simple reports.

With report with parameters or a little more complex I have a Js error stating this :

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; FDM; WWTClient2; .NET4.0C; .NET4.0E; InfoPath.3)
Timestamp: Tue, 5 Oct 2010 13:58:56 UTC


Message: Sys.ArgumentNullException: Value cannot be null.
Parameter name: panelsDeleting[1]
Line: 4723
Char: 21
Code: 0
URI:
http://<SharepointServer>/ScriptResource.axd?d=6iEBSFYsoVA_iKoRgiGHAUV4efTTyw2zxZBwHuMEIY394eHtYQmQ0lNxBCUnQ9Mz5is

Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server

  

I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working.

I then configured the SharePoint site's Reporting Services integration (trusted account), enabled anonymous access and enabled report builder. I can launch report builder without any issues at all. The problem comes when I try to save my report. When Report Builder is started Items->New-ReportBuilder Report it opens and display in the lower left hand corner "No current report server." When I close the Wizard dialog and click connect I enter http://server.fqdn.net and I receive the following error:

Connection failed:

Unable to connect to the server that is specified in the URL, 'http://servername.fqdn.net/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I have also tried http://servername.fqdn.net/reportsserver/. When I try that I receive a login prompt. When I enter my credentials it tries for a few seconds and then sends another login prompt. I installed the report server using default settings. The reporting services db is on the same server as sharepoint. The configuration and other databases are on a remote S

In Sharepoint Integrated Mode whether Report Manager URL http:///Reports will open the

  

Hai Friends,

                I am Ali, In SharPoint Integrated mode ReportManager URL getting This Error [ This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode) ].

1. at the time of SQL Server 2008 R2 installation Reporting services enabled In Native mode.

2  In Reporting service config manager tool http://<serverName>/Reports URL is working in 'Native mode' as Fine. Here i am able to create New Roles and able create New Folders and able to deploy the Reports from BIDS and Report Builder to Report Server.

3. Now , I opened Reporting Services Config Manager Tool and I Created New Data Base(as 'ReportServerTest) In sharepoint Integrated mode.

4. ReportServer Configured Reporting Services in SharePoint Integrated mode Sucsessfully. Granted Data base.

4. Enabled Content Types Sharepoint Library and i am able to deploy .rdl files from BIDS(Designer) to sharepoint library.

5. But i need to Deploy the Reports from Report Builder 3.0 to Report Server In SharePoint Integrated Mode

I Want to op

Report viewer webpart in sharepoint 2010 foundation with Reporting server in native mode, possible?

  

Hi,

We have a product on sharepoint 2010 whose major feature is with the reporting services, we are checking to see if our product can be deployed in a minimum environment of sharepoint 2010 foundation.
we have a minimal test environment with the following :

windows server 2008 R2
SQL Server Express Advanced
Reporting services configured in Native Mode
Sharepoint 2010 Foundation.

I would like to know if we can enable report viewer webpart on sharepoint foundation 2010 with the reporting services in native mode. our plan is that even if the reporting services are not in sharepoint integrated mode, we are thinking of using web services to get XML data and using the XML data in report builder 3.0 to generate reports? will the idea work in this environment? if so can anyone let us know how to get the report viewer web parts in this environment?

Thanks for any help,

- Asif


Password when deploying SSRS report to SharePoint server

  
Hi all,

My task is to display SSRS 2008 reports in SharePoint. Im stuck on the SharePoint - SSRS integration part.

Status:

- Installed an SQL Server 2008 instance on a machine with an MSSQL2005 installation.
- Installed SSRS 2008 in SharePoint integration mode.
- Enabled the Report Server Integration Feature in Site Settings
- Created document libraries for Reports, Data Sources
- Changed the Deploy options to:
                                                         TargetDataSourceFolder - SharePoint Data Sources Library
                                                         TargetReportFolder - SharePoint Reports Library
                                                         TargetServerURL - URL of SharePoint Site
Problem:

Trying to deploy SSRS report(s) to SharePoint server, getting a Reporting Services login window (requesting username and password), but nothing works. I have seen a post about a duplicate entry in the web.config file for Reporting Services. This wasnt the case here. No duplicate entries.

I havent correctly granted database access in SharePoint server (see SharePoint Central Admin -> Application Management -> Reporting Services -> Grant Database access).

When I try this, I get the following error:

The report server i

send report to ftp server and then map the ftp drop folder to sharepoint doc lib

  

Using window file share(ftp://sharepointserver/drop) i want to send the report from the report server machine to the  sharepoint servers ftp drop folder and then by mapping the sharepoint doc lib to the ftp drop folder, upload the reports into sharepoint doc library???

Is this possible??


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