SSRS properties greyed out in SSMS on Windows Server 2008

Came across an issue that held us up for a bit when we installed SQL Server 2008 on Windows 2008 Server.

When connecting to Reporting Services via SSMS, we found that the Report Server properties were "greyed out", meaning that even though we were logged in to the server as members of the admins group, we could not administer the report server properties.

Turns out on Windows server, the trick is to "Run SSMS as Administrator" and then you get full admin rights… see the pic below

SSMS on Win 2008

Leave a Reply