Post reply

What autorization is neccesary for Performancemonitor?

  • July 25, 2005 at 8:46 am

    #89212

    Hi there,

    I want to monitor a SQL Server 2000 machine(running on W2000 server) with PerfMon. I login to that machine via a group, which has System Administrator autority. When I login with QA or EM I have sa-rights. When I try to connect with PerfMon, type the name of the server and want to choose a SQL Server counter I receive the message: unable to connect to server. When trying to monitor on the server itself, everything works a-oke.

    I am not savvy on Windows security and autorization; can anyone tell me what needs to be done to connect via PerfMon to that server? Does the local aplication PerfMon needs some extra autorization? I think I login under my own Windowsaccount, which should have sufficient rights to access that server, but...

    Help?

    Greetz,
    Hans Brouwer

  • July 26, 2005 at 2:21 pm

    #577307

    I use perfmon all the time to monitor my servers.  I am a domain admin, and thus an administrator on all the machines.  SQL Server rights don't matter, it's the permissions through security policy.

    I would check the administrators group on the servers, to make sure you are in there, and add yourself even if you are not.  There may be a more granular way of granting permission, but I don't know what it is.

    Dylan

    Dylan Peters
    SQL Server DBA

  • July 26, 2005 at 6:35 pm

    #577348

    You can access SQL Server counters from inside SQL Server. The sysperfinfo table can be queried for these counters. The following article has the permissions needed to allow access if you're not an admin:

    PRB: SQL Performance Monitor Counters Missing (227672)

    Look at the Problems with the Registry section. Also,

    Troubleshooting Performance Monitor Counter Problems (152513)

    K. Brian Kelley
    @kbriankelley

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply