SSRS 2008 R2 SharePoint 2010 Integrated Mode Error - Help
I have installed and configured a sharepoint 2010 farm with kerberos enabled and configured, for the main part everything works ok. However I keep on receiving this error intermittently usually when a report has been modified. ERROR For more information about this error navigate to the report server on the local machine, or enable remote errors. I have tried enabling ssrs remote errors and restarting ssrs and rebooting the farm but the error still occurs, I am really struggling to fine the root of this issue any help will really be appreciated. I have done this but no joy http://blogs.msdn.com/b/dstfs/archive/2009/05/06/getting-remote-errors-from-sql-server-reporting-services-2008.aspx In addition I have applied December CU for sharepoint and sql2008 r2 Any ideas on how to actually see the error or how to resolve it??? Only other information is that the reports are using SSAS as the data source and the whole environment is virtual (VMWare ESX) Thanks
January 20th, 2011 8:07pm

On each of the reporting servers check the following logs: C:\Program Files\Microsoft SQL Server\MSRS10.[InstanceName]\Reporting Services\LogFiles Also on the SP Application Servers check the following ULS logs (assuming default locations) C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2011 11:19pm

Hi , There are two ways to do it. See that you are connected to the right reportserver Instance.Try the second method as well and Restart the Reportserver 3.1) Enable remote errors through SQL Server Management Studio Start Management Studio and connect to a report server instance. For more information, see How to: Connect to a Report Server in Management Studio in SQL Server Books Online. Right-click the report server node, and select Properties. Click Advanced to open the properties page. For more information, see Server Properties (Advanced Page) - Reporting Servicesin SQL Server Books Online. In EnableRemoteErrors, select True. Click OK. 3.2) Enable remote errors through script Create a text file and copy the following script into the file. Public Sub Main() Dim P As New [Property]() P.Name = "EnableRemoteErrors" P.Value = True Dim Properties(0) As [Property] Properties(0) = P Try rs.SetSystemProperties(Properties) Console.WriteLine("Remote errors enabled.") Catch SE As SoapException Console.WriteLine(SE.Detail.OuterXml) End Try End Sub Save the file as EnableRemoteErrors.rss. Click Start, point to Run, type cmd, and click OK to open a command prompt window. Navigate to the directory that contains the .rss file you just created. Type the following command line, replacing servername with the actual name of your server: rs -i EnableRemoteErrors.rss -s http://servername/ReportServer Regards, PS
January 23rd, 2011 7:39am

I am experiencing the same error. I have tried data connections to tables, views and even resorted to hard coding values into a report but still the error persists At one point i thought i had resolved this error when i resorted to physically uploading the report to the Sharepoint Reports library using the upload function from the toolbar, this certainly limits the occurrance of the error but still the error exists. I have enabled remote errors and still the error doesnt appear in the logs or with no detail at all, It appears in the log as it has rendered successfully, because once you have refreshed the report it eventually renders successful An example of what i see in the SQL SSRS logs at the same time when a report has failed to render on the front end: Processed report. Report='http://Sharepoint Site/Reports/Dashboards/RID_Test_NoData.rdl', Stream='' and another ListChildrenAction(http://Sharepoint Site/sites/bi/Reports/Dashboards, False). Im fairly new to understanding these logs, they mite give away a lot i hope but they mite just mean nothing :-s I have 2 enviroments setup, one with the latest R2 updates and patches and the other which isnt updated with those changes. The updates didnt make any difference Any direction or resolutions would be much appreciated Kind Regards Amz
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2011 11:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics