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


Top 5 Contributors of the Month
ffttt
Post New Web Links

500 Error generating SSRS Report in SharePoint Integrated Mode

Posted By:      Posted Date: November 16, 2010    Points: 0   Category :Sql Server
 

Our environment looks as follows:

- MOSS 2007 Site/Central Admin (Enterprise) on Server A

- SQL Reporting Services 2008 R2 on Server B

- Report created on workstation using Report Builder 3.0

- SharePoint Library (with Promoted InfoPath fields) is the XML datasource

 

The report generates perfectly fine in development, but once loading the RDL up to the SP Site we get the following error when trying to view:

 

An error occurred during client rendering.

The remote server returned an error: (500) Internal Server Error.

 

Using this generic information we have checked into numerous apparent fixes, from confirming settings in the Central Admin, to changing the Zone Authentication to NTLM, to ensuring Anonymous Access is disabled, as well as some tweaks in IIS, etc.

We're still not having any luck getting the report to generate.

Any assistance would be greatly appreciated.




View Complete Post


More Related Resource Links

Report Builder 3 report preview error in SharePoint integrated mode

  
Hello folks! I've faced some strange error with RB 3.  My environment is: Win 2008R2+SQL2008R2 CU3+Sharepoint Foundation services 2010 SharePoint services integrated with Reporting Services.  When I try to run RB3 from SharePoint library and built some report I get strange error at the previw screen : Failed to preview report. The item 'http://myserver/cd6409dc-1089-4e8a..' cannot be found. Details: System.Web.Services.Protocols.SoapException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found.    at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)    at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)  The most intresting thing, that my test environment with Win 2008R2 CTP+SQL2008R@ Nov CTP is working properly without any error. Could you please advise how to resole this problem? Thanks in advance, Andre.  

SSRS 2008R2 - go back to parent report does not work sharepoint integrated mode

  
I'm currently using SharePoint Foundation 2010 with SQL Server 2008R2 with the SharePoint RS add-in. I have a report with a drilldown to another report.  I can drill down correctly to the other report.  But when I do the "go back to parent report" it will take me back to the parent report, but when I try to drilldown again to another report, I get the following error. "Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'. Line: 5 Char: 62099" When I run this report in VS 2008 or Report Builder 3, I have no problems drilling down and back and forth. I only have an issue when I deploy the report to SharePoint.  I have also accessed the RDL directly outside of a webpart page, but still get the same error. Wondering if anyone else is experiencing this issue?

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

Setting Title on SSRS (SharePoint Integrated Mode) subscription.

  
I have some subscriptions in SSRS where the report goes directly to a Document Library on Sharepoint.  The subscription works fine, however, I would like to have the Title of the report be the current date that the report is run.  Is there a way to put a formula such as =[today] in the Title field of the File Options section on the Subscription properties?  I have tried this but either it is not possible or I am not using the correct syntax.  Thanks, Tim Olig

Sharepoint and SSRS Sharepoint integrated mode, any side effect ?

  
Hi, We planned to switch from native mode to sharepoint integrated mode our SQL Server Reporting Server. But it is a production server, so we liked to know if any side effect can happened on existing report and if it is possible to switch an existing database into sharepoint integrated mode ? Thanks, Mathieu Perrin.

While trying to view a report in integrated mode i see an unsupported RPL stream error

  
Trying to deploy a report in integrated mode on MOSS 2007. SQL server version is 2008 R2. I see the following:   ??? ?????????? ? ????м???? ?? ??????? ????????? ??????. ?????????? ?????????????м?? ?????? ?????? RPL: 34.62.1836345404. ??????м?? ??????: 10.3.     Yes i know its in russian. Another fail of Microsoft not being able to see the error codes and strings in english language, makes finding solutions even harder, because first you must find HOW is this called in english, then look for solution. Okay so, i found out that it is actually transalted into: unsupported RPL stream version detected 34.62.1836345404 expected version 10.3 Now, everywhere around the webs they say that this is because my Add-in is out of date and i need new RS addin for MOSS 2007.  But the link is dead!    For example, here http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/61357765-52aa-4085-9ee0-4cb494a6c3ad   @For SQL 2008 R2 together with WSS 3.0 / MOSS 2007, you need the SQL server 2008 november CTP add in:  http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=44bda62c-0cda-4a99-8d0a-d7fe06b39422 But the link is dead and there is no hint as to what happened.   The only valid link i found is this: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=65606fdd-093f-4c

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?

Sharepoint + SSRS -Report Security??? An unexpected error occurred while connecting to the report s

  

I am able to deploy reports and run them as the farm admin that I did the Grant entry for in CA > App Mgt > Reporting Services > Grant DB access.

 

However, my AD personal user that has Local admin on every server has integrated SA security to the SSRS and Sharepoint Database is a Farm admin get's this error trying to run the reoprts.

 

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

 

Now if I log in as the farm admin ( the user I did the grant on) I can run and add the reports to the SSRS webpart... Am I going to have to add every user through that Grant feature? With integrated Sharepoint security there is no /reports virtual to decide what users can run  what reports so I'm not sure..

 

Some  other details.. I'm using Kerberos security, and CA > App mgt > Reporting Services > Manage integration mode is set to Trusted (not Windows).. otherwise .. I can't pull up Default settings under that Reporting Services section of CA.

 

I also d

Report Manager URL http:///Reports is not working in SharePoint Integrated Mode

  

Hello Friends,

I am ali, I am so confused why the Report manager URL(http://<servername>/Reports is not working in sharpoint integrated mode. 

In my local system

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. Here i am able to create New Roles.
3. In Reporting service config tool When i create a new database in sharepoint integrated mode, the the Report Manager URL http://<ServerName>/Reports not working, gettig this error "This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode)"
4 . From both databases(In native mode and sharepointmode) the the webservice URL http://<servername>/ReportServer working fine.

Reporting Services Config manager :

ssrs and sharepoint 2010 integrated mode

  

 

Hello,

 

I have a ssrs server deployed in integrated mode with sharepoint ..and i have a couple of reports deployed to sharepoint server..Now when i go to sharepoint site and view the reports then the first time it displays them correctly but when i change some parameter and then click apply then it stops and gives me this error.

 

 

 

Webpage error details

 

 

 

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)

 

Timestamp: Wed, 20 Oct 2010 14:52:43 UTC

 

 

 

 

 

Message: 'null' is null or not an object

 

Line: 5

 

Char: 27772

 

Code: 0

 

URI: http://test/ScriptResource.axd?d=Py4uDiRG2xcvSKHQoIG5g7XQIl5Ag_3lpZ_2Whd1GKKqcTDzhhbCKzFkdTe3TFZhlvdrXwq3AK-BAMlv5dvADnjhvAReAHeQZLVkLZNeJ2l9TrQuyz4nUfdaZJ1fTgf4jaPnY19Pqz2WZRnQEqe62-zPhqV08iSTnjrTH7ETAAD9jDjV0&t=5c2f384e

 

 

 


Installation of SSRS 2008 in SharePoint integrated mode

  
Hi All,

I have got a server (Windows Server 2003 x64) which has the Office SharePoint server 2007 and SQL Server Reporting Services 2008 (in SharePoint Integrated mode) installed in a stand-alone machine (System configured and installed by some other guy). We want to use the SSRS 2008 in SharePoint integrated mode.

I want to make sure that installation and configuration of system is done properly. But i am a starter, so i don't know much where to start.

Please help me which points i have to check to make sure that system is configured properly.

Also i visited the server and found the followings:
1. In central administration, under Application Management tab, Report Services section is not there. ( I think SSRS 2008 AddIn is not installed)
2. Single MSSSQLServer is created for SQL Server 2008, SSRS 2008 and Office SharePoint Server 2007 (Not sure Please let me know where i can confirm this)

Any help is appreciated.

3.

Thanks, Cool Developer

ssrs and sharepoint 2010 integrated mode

  

Hello,

I have a ssrs server deployed in integrated mode with sharepoint ..and i have a couple of reports deployed to sharepoint server..Now when i go to sharepoint site and view the reports then the first time it displays them correctly but when i change some parameter and then click apply then it stops and gives me this error.

 

Webpage error details

 

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)

Timestamp: Wed, 20 Oct 2010 14:52:43 UTC

 

 

Message: 'null' is null or not an object

Line: 5

Char: 27772

Code: 0

URI: http://test/ScriptResource.axd?d=Py4uDiRG2xcvSKHQoIG5g7XQIl5Ag_3lpZ_2Whd1GKKqcTDzhhbCKzFkdTe3TFZhlvdrXwq3AK-BAMlv5dvADnjhvAReAHeQZLVkLZNeJ2l9TrQuyz4nUfdaZJ1fTgf4jaPnY19Pqz2WZRnQEqe62-zPhqV08iSTnjrTH7ETAAD9jDjV0&t=5c2f384e

 

Can somebody please tell me whats happening.

 


Report action from SSAS to the report in Sharepoint integrated mode

  

Hello Everyone,

Here is my scenario: I have 3 servers namely:
A = SSAS server
R = SSRS server
S = Sharepoint server

From  Server R reports are deployed in Server S. I have the cube in Server A, and have a report action created with the following values:
Report Server: R/ReportServer/Pages
Report Path: ReportViewer.aspx?http://S/ReportsFolder/SampleReport.rdl
with some parameters passed. This opens up the report in the report server from the Server R.

Coming to my actual question: Is there any way to open the report in the sharepoint site with this report action.

Please help...

Thanks,

Kurinji


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

SSRS SharePoint Integrated Mode

  

Hi Everyone,

We have an SSRS instance under SharePoint Integrated Mode. I just want to know what my options are for deploying SSRS reports. Would it be ok if I don't install SharePoint on the SSRS box? SSRS and SharePoint are on different hardware. Please advise.

Thanks in advance.

 


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> 

Upgrade from SQL Server 2005 to SQL Server 2008 from SharePoint 2007 SSRS 2005 integrated mode

  

I"m attempting to upgrade from SQL Server 2005 to SQL Server 2008 R2 x64 Enterprise on a server running Windows Server 2003 x64 Enterprise, SharePoint 2007 Enterprise, and SQL Server 2005 and SSRS 2005 Enterprise running in integrated mode.

I installed the Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies from here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en.

When attempting to install Report Builder 2.0, I get the error "Reporting Services Add-in for SharePoint products and technologies is not installed."

When I try to run a report (existing 2005 reports already deployed), I get the error: "Operation is not valid due to the current state of the object." The log has repeating ReportingServicesService.exe errors: #20015: Cannot open "Resources.en-US.resx": no such file or folder, and: Localized resource for token 'ManageDatasetCaching_Desc' could not be found for file with path: "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Features\ReportServer\ItemCustomActions\ecbExtension.xml" among other things.

I've tried rec

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