Activity Monitor gives Access is Denied

_{Tuesday, April 23, 2013 3:13 PM}

Hi,

  When I try to open Activity Monitor from SSMS I receive the message "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)". - more details below.

  I have a SQL Server 2012 Enterprise SP1 installed in an Active/Passive cluster configuration on Windows 2008 R2 Enterprise SP1.

  The problem happens using sa and a domain administrator. Do you know how to fix it?

more details

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)

   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
   at Microsoft.SqlServer.Management.ResourceMonitoring.SqlPerfmonProcessReader.get_LogicalCpuCount()
   at Microsoft.SqlServer.Management.ResourceMonitoring.SqlPerfmonProcessReader.GetSqlProcessCpuUtilization()
   at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundSqlCpuTask.Execute()
   at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundWorkRequest.Execute()
   at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundWorkRequestQueue.BackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

Thank you,

Cassio.

_{Tuesday, April 23, 2013 3:16 PM ✅Answered}

This Connect item may be relevant -- http://connect.microsoft.com/SQLServer/feedback/details/770897/after-installing-sp1-sql-server-2012-activity-monitor-gives-access-denied

Alex

_{Tuesday, April 23, 2013 6:06 PM}

Aleksandr,

  It helped indeed, but I didn´t need to follow all steps.

  In my configuration it was necessary to add only Remote Activation in COM Security / Edit Limits... - even accessing from local server.

  The domain group in which my user is already had Remote Activation right. But to solve my problem I needed to assign this right to a machine local group. Perhaps it´s a characteristic of a cluster configuration.

  After that, sa user become able to see Activity Monitor as well, at least in my Windows session.

Thank you very much,

Cassio.

_{Wednesday, September 11, 2013 8:03 AM}

Hi all,

Have the same problem, ad group and sql user 'sa' are not able to start activity monitor localy connected to sql server 2012 sp1. (Access denied).

Setting the above mentioned DCOM workaround did NOT help.

Any other ideas ?

TIA
acki4711

_{Wednesday, September 11, 2013 8:12 AM | 3 votes}

Well folks, forget the DCOM Workaround, just start SSMS 'as administrator' and activity monitor works perfect... ;-)

HTH
acki4711

_{Sunday, May 10, 2015 12:53 AM | 1 vote}

It does indeed.

Weird thing - it worked from remote servers without a problem, but not locally.

Starting SSMS on the server itself as Administrator allows to use Activity Monitor. 

_{Wednesday, November 16, 2016 9:32 PM | 1 vote}

The issue and solution are identical in SQL Server 2014 Enterprise edition with SP 2 plus the security patch (12.0.5203.0).

_{Friday, May 5, 2017 8:12 AM}

Many thanks! Works perfect!