Activity Monitor gives Access is Denied

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.

April 23rd, 2013 3:13pm

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

  • Marked as answer by Cassio Roque Tuesday, April 23, 2013 6:06 PM
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2013 3:16pm

Aleksandr,

  It helped indeed, but I didnt 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 its 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.

April 23rd, 2013 6:06pm

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

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2013 8:03am

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

HTH
acki4711

September 11th, 2013 8:12am

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. 

Free Windows Admin Tool Kit Click here and download it now
May 9th, 2015 8:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics