03 June 2015

SSMS Activity Monitor - access denied

If you receive the message "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)" when trying to open Activity Monitor from SQL Server Management Studio you should try to start SSMS as administrator. If that does not help follow the suggested workaround in this connect post:

https://connect.microsoft.com/SQLServer/feedback/details/770897/after-installing-sp1-sql-server-2012-activity-monitor-gives-access-denied

I had this issue in a failover cluster starting as administrator solved it for me.

No comments: