Post reply

How to identify SQL SERVER clustred or unclusterd

  • November 3, 2011 at 5:50 am

    #246176

    Hi,

    I have minimum user access in public, and RDP connection was disabled for no one connect that server remotely. But I can able connect through SSMS at client machine, In this case How to identify SQL SERVER clustered or not-clustered? except using this script, or another option?

    select

    CASE WHEN CONVERT(char(20),

    SERVERPROPERTY('ISClustered')) = 1 THEN 'Clustered' WHEN CONVERT(char(20),

    SERVERPROPERTY('ISClustered')) = 0 THEN 'NOT Clustered' ELSE 'INVALID INPUT/ERROR' END

    Thanks

    ananda

  • November 3, 2011 at 5:57 am

    #1402582

    You can use this query

    "SELECT * FROM sys.dm_os_cluster_nodes"

    As per books online, "This view returns a row for each node in the failover cluster instance configuration. If the current instance is a failover clustered instance, it returns a list of nodes on which this failover cluster instance (formerly ‘virtual server’) has been defined. If the current server instance is not a failover clustered instance, it returns an empty rowset."

    But you need to have sufficient privileges to run this query.

    M&M

  • November 3, 2011 at 6:00 am

    #1402584

    Thanks for your reply

Viewing 3 posts - 1 through 2 (of 2 total)

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