Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL server instance ip's Expand / Collapse
Author
Message
Posted Sunday, October 17, 2010 10:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:10 AM
Points: 39, Visits: 528
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,
Post #1005989
Posted Monday, October 18, 2010 2:34 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 6,619, Visits: 14,185
is this a Windows 2003 or Windows 2008 cluster?

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1006598
Posted Monday, October 18, 2010 9:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:10 AM
Points: 39, Visits: 528
its Windows 2003. But would it not be the same with Windows 2008
Post #1006695
Posted Tuesday, October 19, 2010 1:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 6,619, Visits: 14,185
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"
Post #1006754
Posted Tuesday, October 19, 2010 1:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:10 AM
Points: 39, Visits: 528
Thanks Perry, But is there a T-SQL statement to know this incase a user doesn't have RDT access.

Thank you.
Post #1006765
Posted Tuesday, October 19, 2010 3:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 6,619, Visits: 14,185
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"
Post #1006817
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse