How to find out other nodes in SQL Server cluster?

Question

Post reply

How to find out other nodes in SQL Server cluster?

YTZ

SSCommitted

Points: 1707
More actions
August 19, 2010 at 7:14 am

#157157

ALL:
I have SQL Server 2005 SP3 on Windows 2003 and know this is clustered by SERVERPROPERTY('IsClustered') =1. How to find out other nodes info such as instance name?
Thanks
ZYT

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 1

Cluster Manager will provide you with all that information.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

george sibbald SSC Guru Points: 104210 More actions · Answer 2

All available from cluster admin tool under administrative tools

---------------------------------------------------------------------

YTZ SSCommitted Points: 1707 More actions · Answer 3

David:

Thanks.

Is there any t-SQL script that can work from Query Analyzer?

ZYT

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 4

YTZ (8/19/2010)
Is there any t-SQL script that can work from Query Analyzer?

This will get you the physical node name;

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

However, if you don't have access to Cluster Manager then you will be limited in what information you can get about the cluster. Best to get that from the Server Admin team if you don't have explicit permissions yourself.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

YTZ SSCommitted Points: 1707 More actions · Answer 5

David:

Thanks

SERVERPROPERTY('ComputerNamePhysicalNetBIOS') offers local node physical name. I am looking for other node names.

ZYT

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 6

Yes, that is correct. That is all that I know how to get from T-SQL aside from what you originally posted.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot