SQL and ML Spaces

Here are few ways  to enable remote errors in SSRS.

(Even though web.config is available in the reporting services folder on the server where SSRS is installed, it doesnt have an option to enable remote errors)

Native Mode :

• open SSMS, connect to the reporting services, mention the servername. Then right click the properties and look for advanced option at the end of all options and make enableremoteerrors as true.

• Connect to the DB engine from SSMS, enter the servername and use below query :

[cc lang=”sql”]

use [ReportServer]
go

update [ConfigurationInfo]
set value = ‘True’
where name = ‘EnableRemoteErrors’

select * from [dbo].[ConfigurationInfo]
where name = ‘EnableRemoteErrors’

[/cc]

Then restart the reporting services service for the changes to effect.

• Import the EnableRemoteErrors.txt file
• rename to EnableRemoteErrors.rss and copy to a temp folder
• Navigate to the temp folder and issue below command

rs -i EnableRemoteErrors.rss -s http://servername/ReportServer