Sunday, September 21, 2008

Enabling Remote Errors in SQL Reporting Services

Recently working with reporting services, I ran into this error:

“For more information about this error, navigate to the report server on the local server machine, or enable remote errors.”

The scenario is that reporting services lives on a different box than the SharePoint installation.  The fix is to simply set a flag in a configuration table in the Reporting Services database on the report server.  Pull up a new query in SQL Server Management Studio and run the following UPDATE statement and you should be good to go! 

USE ReportServer
GO

update configurationinfo
set value = 'True'
where name = 'EnableRemoteErrors'
GO

No comments: