SQL Server failover cluster - determine active node

sql-server windows sql-server-2008 cluster-computing failover
SilverSkin picture SilverSkin · Dec 20, 2010 · Viewed 7k times · Source

Is there a way to programmatically determine which node in a SQL Server failover cluster is the active node? Or at least determine whether the current machine is the active node?

I have a Windows program which runs on both physical nodes in a failover cluster, but that should operate differently depending on whether it is running on the active node. Part of the reason is that this program should not run simultaneously on the inactive and the active node.

(I've read a bit about making the program cluster aware, but that seems heavily overkill for this simple scenario.)

Answer

Joe Stefanelli picture Joe Stefanelli · Dec 20, 2010

From SQL Server:

Select ServerProperty('ComputerNamePhysicalNetBIOS')

You can also access it through the Microsoft.SqlServer.Management.Smo Namespace as shown here.

Related questions

Access denied for enabled xp_cmdshell for the admin user

I'm using xp_cmdshell within a database trigger to launch a exe file. xp_cmdshell is enabled(it can execute simple cmd command like 'echo'). But when I try to launch the exe through xp_cmdshell, the access is denied. …

Read More
Can't connect to SQL 2012 remotely by IP and named instance

First off, I already know that Windows Firewall is blocking my connection -- I just don't know what to do about it. When I turn WF all the way off, my remote connection works. I already have a Rule to …

Read More
exception has been thrown by a target of invocation in Visual Studio 2013

Today when I opened Visual Studio 2013 Professional Edition, I got the error exception has been thrown by a target of invocation. Also I tried to open ILSpy to debug a dll, but it crashed. I think that it might be …

Read More