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" 😉