question

Steinar avatar image
Steinar asked

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!

performanceclusternetworksetup
10 |1200

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

1 Answer

·
sp_lock avatar image
sp_lock answered

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 comment
10 |1200

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

Steinar avatar image Steinar commented ·
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 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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