Share via

Find IP address and detail of cluster sql instance

  • Article

Question

Wednesday, May 2, 2012 3:56 PM

Hi All,

I am new to sql server..Could you please  help in finding info regarding cluster physical server they reside on and Ip address of the instances and how to connect sql clustered instance with IP address.

Thanks,

Nani

Thanks, Nani.

All replies (5)

Wednesday, May 2, 2012 4:28 PM ✅Answered | 1 vote

yeah, something like 192.168.0.1,1234

If it's the default instance, you don't need the port number

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Wednesday, May 2, 2012 7:41 PM ✅Answered

you can use CMD commands -

c:\cluster res "Cluster IP Address" /priv

and below are some useful info=

>>If you need the Node name on which SQL Server Instance is Currently running-

using T-sql

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [CurrentNodeName] 
It is standalone  then the above query gives the Host Name of the Server.

2.Find SQL Server Cluster Nodes-

SELECT * FROM fn_virtualservernodes() 

or

SELECT * FROM sys.dm_os_cluster_nodes 

3.Find SQL Server Cluster Shared Drives

SELECT * FROM fn_servershareddrives() 

or

SELECT * FROM sys.dm_io_cluster_shared_drives

Also same question is exists in other cateogry ->

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/c9ef1a7b-65f9-4556-9db4-94bedc190e6a

Rama Udaya.K ramaudaya.blogspot.com Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Wednesday, May 2, 2012 4:12 PM

Hi,

What version of Windows and SQL Server are you using?

You can use the cluster administrator to find out details of the nodes participating in the cluster, the cluster ip address, cluster name, etc. by examining the properties of each resource.

You can use the ip address from the cluster ip address to connect, ie. 192.168.0.1\myinstance...

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Wednesday, May 2, 2012 4:22 PM

Thank you for your reply.

Sql version :2008R2  Enterprise.

How to connect to sql  instance with ip only without instance name do we need to use port number?

192.68.0.1,portnumber(1433) is this correct?

Thanks, Nani.

Wednesday, May 2, 2012 5:48 PM

I tried it with IP,Portnumber and it worked .

Do we have any sql query to get Cluster instance IP addresses without using GUI.

Thanks, Nani.