Tuesday, March 17, 2009  by Marc Charmois - About Me / Previous Posts / Archives - Home

Check error messages for SQL Server Reporting Services 2008

Enable remote errors for Reporting Services 2008 - Check Reporting Services 2008 Log Files

Introduction

When you are working with Reporting Services 2008 in SharePoint Integrated Mode, you may encounter this error message in a Report Viewer Web Part or the RSViewerPage.aspx.
"For more information about this error, navigate to the report server on the local server machine, or enable remote errors"

If you want to know more about the error, you have 3 solutions:
  • Navigate to the Report Server Web Service on the computer where Reporting Services is installed.
  • Check the Reporting Services Log Files on the computer where Reporting Services is installed.
  • Enable Remote Errors


1 - Navigate to the Report Server Web Service
There is two ways obtaining the Report server URL for Reporting services 2008 in SharePoint Integrated Mode.

In SharePoint Central Administration



In the Reporting Services Configuration Manager.



When you navigate to this URL, you have access to a more explicit error message.



2 - Reporting Services 2008 Log Files location
Depending on the drive you have chosen to install your Reporting Services instance, the physical path to the Log Files where you can search for errors is the following:

C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles

You will find errors description with stack traces.



3 - Enable remote errors for Reporting Services 2008

There is no way of enabling Remote Errors modifying the Reporting Services Web.config file
(c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\Web.config).

In order to enable Remote Errors you have to connect to the Database Engine and update a row in the ConfigurationInfo table of the Report Server database.
You can do it performing a Tansact SQL Request



or by editing the table and make the change manually.





You have to restart Reporting Services Service after that.







Labels: , ,

3 Comments:

Blogger Lewis N. Clark said...

Depending on the drive you have chosen to install your Reporting Services instance, the physical path to the Log Files where you can search for errors is the following: Senuke Services

March 16, 2014 at 8:12 AM  
Blogger Toàn Cù Huy said...

Thanks

December 26, 2014 at 5:07 AM  
Blogger Prologic Corporation said...

This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,
Getting your applications talking is the key to better business processes,
Rapid web services solutions for real business problems,
Web-based Corporate Document Management System,
Outsourcing Solution,
Financial and Operations Business Intelligence Solution,

Our address:
2002 Timberloch Place, Suite 200
The Woodlands, TX 77380
281-364-1799

prologic-corp

February 8, 2015 at 2:58 PM  

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home