Post reply

SQL server instance ip's

  • October 17, 2010 at 10:43 pm

    #229777

    Hi All,

    Can anyone advise on how to find on which ip is my SQL server instance running on a Cluster node.

    Assuming that we have some 5 to 6 ip's. Is there any query/T-sql we can run to check this.?

    ( offcourse i would know what the SQL instance is on by seeing my

    Instance).

    Any help is much appericiated.

    Thanks in Advance,

  • October 18, 2010 at 2:34 pm

    #1238731

    is this a Windows 2003 or Windows 2008 cluster?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • October 18, 2010 at 9:36 pm

    #1238815

    its Windows 2003. But would it not be the same with Windows 2008

  • October 19, 2010 at 1:27 am

    #1238858

    Clustering has changed a lot between the 2 platforms. On the Cluster node go into cluster administrator and select the resource group for the instance you wish to view details. Inside this group will be an IP address resource, double click to view the properties and find the IP address.

    Why don't you have all these details documented, this would be the most sensible option.

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • October 19, 2010 at 1:56 am

    #1238866

    Thanks Perry, But is there a T-SQL statement to know this incase a user doesn't have RDT access.

    Thank you.

  • October 19, 2010 at 3:45 am

    #1238911

    gaganks (10/19/2010)

    Thanks Perry, But is there a T-SQL statement to know this incase a user doesn't have RDT access.

    Thank you.

    Not as I remember, the entry point into the clustered instance is via the virtual network name. You could ping this and get the IP address that way.

    Personally, I always document the systems that I work with so that resources may be identified immediately without having to interrogate the cluster!

    Execute the following query against your clustered instance to find the name info

    select

    serverproperty('ComputerNamePhysicalNetBIOS') as PhysicalComputerName,

    SERVERPROPERTY('MachineName') AS VirtualNetworkName,

    SERVERPROPERTY('ServerName') as FullInstanceName

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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