‘properties’ option is greyed out for ssrs instance when you right-click in ssms

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

ssrs through ssms with admin

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.

ssrs through ssms no admin

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’

run as administrator