AWGMorrison
asked on
Perfmon not displaying SQL counters remotely for non Admins
I have a user that needs to be able to run perfmon remotely to monitor SQL server counters.
I have configured the server as per this article and the user is able to use Perfmon remotely whereas before he would get access denied. We are using SQL and Windows 2000.
http://www.webservertalk.com/archive46-2004-6-289063.html
The problem is that he is unable to see the SQL (or SMS which isn't relevant) counters remotely. When I connect as admin locally and remotely I get the full list of counters from the dropdown list including SQL. This shows it isn't related to the countless issues people have had where SQL counters disappear completely for everyone.
I suspect there is either a registry entry or DLL that needs to give Read access to the user but I have no idea which one it might be. As far as I can tell from following these steps, the user should have read access for all "Services".
I also cannot find an article that tells me how Perfmon works with regard to the counters.
I have configured the server as per this article and the user is able to use Perfmon remotely whereas before he would get access denied. We are using SQL and Windows 2000.
http://www.webservertalk.com/archive46-2004-6-289063.html
The problem is that he is unable to see the SQL (or SMS which isn't relevant) counters remotely. When I connect as admin locally and remotely I get the full list of counters from the dropdown list including SQL. This shows it isn't related to the countless issues people have had where SQL counters disappear completely for everyone.
I suspect there is either a registry entry or DLL that needs to give Read access to the user but I have no idea which one it might be. As far as I can tell from following these steps, the user should have read access for all "Services".
I also cannot find an article that tells me how Perfmon works with regard to the counters.
James Murrell
have you rad http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic13151.aspx
ASKER
Thanks for the suggestion. I don't think that really helps but if I am honest I don't really understand a lot of the article as I am not a DBA or a developer.
I am going to post on the MS forums and see if I get any response.
I am going to post on the MS forums and see if I get any response.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
cool sorry my link did not solve but glad you found a solution and posted here
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
Vee_Mod
Community Support Moderator
After following the above steps, I am able to view the remote machines performace counters except the SQL related counters. I am able to view these SQL counters with admin account.
I am unable to find SQLCTR80.dll in SQL binn directory to give read permissions. I think this could be the reason behind the problem. I am running SQL server 2005 and I don't have this dll inside installation directory.
Any once else faced this problem? Do I need to copy and registrer this dll manually?
I am unable to find SQLCTR80.dll in SQL binn directory to give read permissions. I think this could be the reason behind the problem. I am running SQL server 2005 and I don't have this dll inside installation directory.
Any once else faced this problem? Do I need to copy and registrer this dll manually?
deshaw,
Please use the 'ask a related question' function and open your own question. Doing so will send an alert to everyone who participated in the question.
The only reward the Experts get for helping you is the electronic 'points' offered with new questions.
You are a Premium Service member with unlimited points - so there is no additional cost to you.
Vee_Mod
Community Support Moderator
Please use the 'ask a related question' function and open your own question. Doing so will send an alert to everyone who participated in the question.
The only reward the Experts get for helping you is the electronic 'points' offered with new questions.
You are a Premium Service member with unlimited points - so there is no additional cost to you.
Vee_Mod
Community Support Moderator