Monday 13 June 2016

Enabling Remote Errors in SSRS In Ax 2012

By default the remote errors property in SQL Server Reporting Services is set to false, which means error messages in a multi-server environment aren't very detailed.  By enabling remote errors, you will get additional error information returned which is more useful than this:
For more information about this error, navigate to the report server on the local server machine, or enable remote errors.

Option 1 to Enable Remote Errors - DB Engine
1.  Connect to the database engine in SSMS and navigate to the ReportServer database.
2.  Query the ConfigurationInfo table to get familiar with it.  Issue the following query:

USE ReportServer
GO

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

Option 2 to Enable Remote Errors - Report Server
This option applies to SQL Server 2008 and newer.
1.  Connect to Reporting Services in SSMS.
2.  Right-click on the server node and go to Properties.
3.  On the Advanced page, set the EnableRemoteErrors property to True.



1 comment:

  1. Nice article Aslam. I was searching for some good tips on Dynamics Ax. Glad to know this. Thanks for sharing this slice of information with us. Currently I am learning Ax from http://tekslate.com/microsoft-dynamics-ax-training/

    ReplyDelete