July 20, 2010 at 7:06 am
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
select serverproperty('isclustered')
This should help
-- Gianluca Sartori
July 20, 2010 at 7:54 am
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