Re: Permissions required to view SQL counters in System Monitor

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/26/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Thu, 26 Sep 2002 06:37:05 -0600

It's a permissions issue at the operating system level.
Refer to the following for information on how to configure
this for NT 4 or Windows 2000:
Enabling Non-Admin Users to Remotely Monitor with PERFMON
http://support.microsoft.com/?scid=kb;en-us;Q158438

-Sue

On Wed, 25 Sep 2002 08:18:21 -0700, "Shane"
<shane_klosowski@allianzlife.com> wrote:

>While attempting view Performance data in Win2K System
>Monitor of the SQL servers in our enterprise, I am unable
>to see the SQL performance counters, even though all other
>counters are visible. I have tried applying permissions
>on the various SQL server registry keys, but have had no
>success. The only thing that resolves the issue is to put
>my account in the local Administrators group of the
>server. I did this on a small test box and was
>successfully able to view the SQL counters. However, I am
>not a domain or local admin on any of our production
>servers, so I need to be able to view the SQL counters in
>System Monitor without local or domain admin permissions.
>
>My question, therefore, is: What are the necessary
>permissions (SQL, Registry, NTFS) and Rights for a non-
>Admin to view and record SQL Performance counters?
>
>Any assistance would be appreciated.

Relevant Pages

  • Permissions required to view SQL counters in System Monitor
    ... Monitor of the SQL servers in our enterprise, ... System Monitor without local or domain admin permissions. ... Admin to view and record SQL Performance counters? ...
    (microsoft.public.sqlserver.security)
  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)