How to get addresses of SQL Server cluster nodes through sql query

Asked Jul 20 '17 at 06:26

Active Jul 20 '17 at 06:55

Viewed 2,265 times

1

Is there any way to get addresses of cluster's nodes via SQL query for SQL Server cluster?

asked Jul 20 '17 at 06:26

user6793512

23
5

What kind of cluster, failover or load balancing? – Peter Jul 20 '17 at 09:45

1 Answers1

0

Please check the below links

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/eb2e7260-e408-4daf-b72a-8d05109266b5/find-ip-address-and-detail-of-cluster-sql-instance?forum=sqldisasterrecovery

SQL - Query to get server's IP address

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c9ef1a7b-65f9-4556-9db4-94bedc190e6a/find-ip-address-and-detail-of-cluster-sql-instance?forum=sqlsetupandupgrade

answered Jul 20 '17 at 06:55

SQL006

439
6
21