Missing SQL perfmon counters in 2003 Cluster

Hi,
I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive), one
of the active server is missing the SQL performance counters, the weird
thing is, if I run Perfmon remotely connecting to this node, it will not
display any SQL Performance counters but if I login locally to the server
and run Perfmon, it will show the SQL performance counters.
Any idea why is this happening.
Thanks
Ayad
Permissions.
Try running the performance monitoring service using a real domain account
rather than the Network Service account.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:O59UFK28EHA.2572@.tk2msftngp13.phx.gbl...
> Hi,
> I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive),
one
> of the active server is missing the SQL performance counters, the weird
> thing is, if I run Perfmon remotely connecting to this node, it will not
> display any SQL Performance counters but if I login locally to the server
> and run Perfmon, it will show the SQL performance counters.
> Any idea why is this happening.
> Thanks
>
> Ayad
>