To adjust some of the properties of a SQL Server Reporting Services instance , for example, how long the execution logs are retained, or whether or not you display meaningful error messages to the user, you have to do the following:
- go into SQL Server Management Studio,
- connect to the SSRS instance, then
- right-click on the instance name and
- select Properties from the drop-down menu
However 9 times out of 10 when I do this (in my defence, I don’t do it very often….) I find that properties is greyed out, despite having logged on as a privileged user.
The ‘fix’ for this is fairly straightforward – you have to run SSMS with ‘Run as Administrator’ i.e. right-click on the SSMS icon or menu option and opt to ‘Run as Administrator’