IS_CLUSTERED not showing Clustered Instance

• Claudio Gatto

  SSC Veteran

  Points: 287

  More actions

  July 9, 2019 at 6:33 am

  #3661011

  Hi,

  I have a many clustered instances installed on a Windows Server 2012 Failover Cluster. For my SQL 2016 instances and some SQL 2012 instances, the IS_CLUSTERED and CLUSTER_NODENAME from the dmv "sys.dm_server_services" show "N" and Null respectively.

  However, the "SELECT SERVERPROPERTY('IsClustered')" correctly displays a "1".

  I am running both queries as a SYSADMIN.

  Any ideas? Am I encountering some sort of bug?

  Regards

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 10, 2019 at 7:10 am

  #3661462

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.