Enable error reporting - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Enable error reporting

Author

Topic

roy mm
Yak Posting Veteran

62 Posts

Posted - 2007-02-06 : 04:31:18

Hello,
I got the error:
______________________
Reporting Services Error

* For more information about this error navigate to the report
server on the local server machine, or enable remote errors SQL Server
Reporting Services
______________________

I saw the answer:
"You could set the "EnableRemoteErrors" configuration value to True in
the ReportServer.ConfigurationInfo database table."

How can I get to the ReportServer.ConfigurationInfo database table?

I am on the reportservice server and I run "reporting services
configuration manager" and the "sql server managment". I didn't saw
that option :(

Where is this configuration?

Any help?
Thanks

jhermiz

3564 Posts

Posted - 2007-02-07 : 12:05:12

quote:
Originally posted by roy mm

Hello,
I got the error:
______________________
Reporting Services Error

* For more information about this error navigate to the report
server on the local server machine, or enable remote errors SQL Server
Reporting Services
______________________

I saw the answer:
"You could set the "EnableRemoteErrors" configuration value to True in
the ReportServer.ConfigurationInfo database table."

How can I get to the ReportServer.ConfigurationInfo database table?

I am on the reportservice server and I run "reporting services
configuration manager" and the "sql server managment". I didn't saw
that option :(

Where is this configuration?

Any help?
Thanks

ConfigurationInfo is an actual table in the reporting services server (the actual ReportServer database on your SQL Server 2k/2k5 box). You need to issue an update command to set this option. It is very simple:


UPDATE ConfigurationInfo SET Value = 'True' WHERE Name='EnableRemoteErrors'

Take a look at a helpful article I wrote about the Power of the ReportServer here:

http://jhermiz.googlepages.com/powerofreportserver

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources