Cluster related problem

Question

question

Steinar asked Feb 4, '10

Cluster related problem

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!

performance cluster network setup

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-02-04T10:51:19Z

sp_lock answered Feb 4, '10

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.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steinar commented · Feb 05, 2010 at 06:22 AM

Thanks, I am with you so far. The problem is that I can not use the virtual server name to connect to such things as Perfmon counters and shared drives. For example v: is the backup disk in SQL01\PROD01. If SQL01\PROD01 resides on Node1 i can map to v: using \\node1\v$ and if SQL01\PROD01 resides on Node2 I can map to it using \\Node2\v$. However I can not map to it using \\SQL01\v$ wich is what I want.

0 ·

question