dbTalk Databases Forums  

Re: Cluster IP address, Max number of nodes in a cluster

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering Re: Cluster IP address, Max number of nodes in a cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Re: Cluster IP address, Max number of nodes in a cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM





1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #2  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM





1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #3  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM


1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #4  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM


1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #5  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM


1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #6  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM


1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #7  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM


1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #8  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM


1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #9  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM


1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
  #10  
Old   
Tim Walsh
 
Posts: n/a

Default Re: Cluster IP address, Max number of nodes in a cluster - 06-16-2008 , 03:45 AM


1) Query DNS, I'm assuming you know the hostnames.
2) Have you looked at the WMI class MSCluster to see what it makes available
on your windows 2000 box? You can use the WBEMTest.exe tool to take a look
at what's available. I believe you have to point it to root/mscluster
instead of the default value root/default or the normal root/cimv2.


<Aniket.Dumbare (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL
http://msdn.microsoft.com/en-us/libr...59(VS.85).aspx

PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster is MS SQL Server Cluster. I need to find the IP address of
the SQL Server also.

There is a COM interface which provides the functionality to gather
this information, IClusCfgClusterInfo but my code is supposed to
support Windows 2000 OS also, so cannot use this interface. There is
an API provided by Failover Clustering, called
ResUtilGetCoreClusterResources() using which I am able to find the IP
address of the Cluster but again this API is introduced in Windows
2003 and not supported with Windows 2000

In short I want to gather following values for SQL Server Cluster

1. Cluster IP address
2. SQL Server(s) IP addresses
3. Maximum number of nodes supported by the cluster

on Win 2K as well as Win 2K3

Is there any way to retrieve this information

Thanks in advance

Regards
- Aniket



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top