Setup: 2 x Win 2008 servers clustered using Microsoft Clustering Services 3 x SQL Server 2008 Ent edt instances in the cluster
Nodenames Node1 adn Node 2 SQL Instances SQL01\PROD01 , SQL02\PROD02 and SQL03\PROD03
Problem: Connecting to virtual clustered network names SQL01, SQL02 adn SQL03 to collect Perfmon data. If I want to get performance counters for CPU, and MSSQL$PROD01 I have to connect to the node in the cluster that currently holds SQL01\PROD01. On win2003 I could always connect to SQL01.
I am pretty sure that this is NOT an actual SQL Server problem but rather a cluster/windows security och config issue. But any pointers would be appreciated!