Advanced Property SQL Server Reporting Service

Advanced Properties in SQL Server Reporting Service.

If you are using SQL Server Reporting Service 2008 then you can get Advanced property from Management Studio itself. Connect to Reporting Service in Management studio, Click on server node for properties then click on advanced.

If you are using SQL Server Reporting Service 2005 then you cant get it from management studio.There is a table ConfigurationInfo in reportserver database where you need to update this properties.

SELECT * FROM configurationinfo
you have to update related property in the table.

Fox Ex. if you want to enable remote errors

UPDATE configurationinfo SET VALUE = N'True' WHERE name = 'EnableRemoteErrors'

Lets see this properties in short.

Enables/Disables My Reports folder

Role which will be used for My Reports Folder.


Determines whether the RSClientPrint ActiveX control is available for download from the report server. The valid values are true and false. The default value is true.

Enables/Disables execution logging

Number of days you want to keep executionlog. Default is 60

session Timeout in seconds. Default value is 600.

Read-only property . Indicated whether Reporting Service is integrated with Sharepoint

Name of site displays on Report Manager

Number of days when stored parameter can be stored. Default is 180 days.

Number of Parameters that can be stored.Default value is 1500.

Decided whether use session cookies when communicating with client browsers. Default is true.

Decides time during which external image should be retrived before the connection is timed out. Default is 600 seconds.

Defines compression method of snapshots

SQL = Snapshots are compressed when stored in the report server database. This is the current behavior.

None = Snapshots are not compressed.

All = Snapshots are compressed for all storage options, which include the report server database or the file system.

Time in seconds , after than server will stop processing reports. Default is 1800

Determinsed maximum number of snapshots.Default is -1 means no limit.

Determines whether Windows integrated security is supported for report data source connections. The default is True. The valid values are as follows:

Select this option to specify whether users can perform ad hoc report execution from a Report Builder report. Setting this option determines the value of the EnableLoadReportDefinition property on the report server.

If you clear this option, the property will be set to False and report server will not generate clickthrough reports for reports that use a report model as a data source. Any calls to the LoadReportDefinition method will be blocked.

Turning off this option mitigates a threat whereby a malicious user launches a denial of service attack by overloading the report server with LoadReportDefinition requests.

Decides whether give error information related to Reporting Service to remote computers
Default is False.


Specifies whether Report Builder installation package can be downloaded from the report server. If you clear this setting, the URL to Report Builder will not work.
In SQL Server Reporting Service.


Post a Comment

Popular Posts