Post reply

Is SQL server part of a cluster?

  • July 20, 2010 at 7:06 am

    #139915

    Hello,

    I work for a software vendor. We often go into shops remotely and configure software on an application server that is provided. We have a piece of software that integrates with SSRS. SSRS should not be on MS cluster. Does anyone know of a query to determine if an SQL data engine is on an SQL cluster. Generally our clients put SSRS on the same server as the SQL data engine. So if i could determine if the data engine was on a cluster that would help me know if the SSRS installation was on a cluster. If it is i would ask the client to install it somewhere else.

    Any TSQL out there that would allow me to figure this out. I generally do not have access to the SQL server itself and often cannot find the appropriate client resource to ask.

    Also, does @@SERVERNAME return the DNS alias or the actual node DNS name when the node is part of a cluster? That might be helpful.

    Jimmy

    "I'm still learning the things i thought i knew!"

  • July 20, 2010 at 7:31 am

    #1195505

    select serverproperty('isclustered')

    This should help

    -- Gianluca Sartori

  • July 20, 2010 at 7:54 am

    #1195535

    Thanks, this will work for me!

    Jimmy

    "I'm still learning the things i thought i knew!"

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

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