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!
Answer by sp_lock ·
A snippet from MSDN
Multiple Instances of SQL Server on a Failover Cluster
The instance can be either a default instance or a named instance. The virtual server looks like a single computer to applications connecting to that instance of SQL Server. When applications connect to the virtual server, they use the same convention as when connecting to any instance of SQL Server; they specify the virtual server name of the cluster and the optional instance name (only needed for named instances): virtualservername\instancename. For more information about clustering, see Failover Clustering Architecture.