finding the active node in Failover Cluster

I am looking at the Windows 2012 Server and sql server 2012 is installed on this server..and I am confused about which node is active? when I look at the Failover Cluster manager,I see the Cluster name and Current host server there ;see attached file

 there are two nodes;


 Cluster Name: SQL12CLU
 Current Host name: SQL12CLUB

 but when I look at the Roles in Failover Cluster management, SQL12CLUA seems to be owner node so why are they different? I think, the server in the Owner Role should be Active node,which is SQL12CLUA but on the other hand, I see the SQL12CLUB as a Current host name.. so is there any way about how to find the active node in FCM?
Teoman SahinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Benjamin VoglarIT ProCommented:

You have CLUSTER name SQL12CLU and you have configured ROLE name ISQLAPPAG1 and the owner of this role is fizical server named SQL12CLUA.

You can restart the SQL12CLUB server because the SQL12CLUA is the owner.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Teoman SahinAuthor Commented:
many thanks Benjamin so just out of curiosity  I would like to ask you something about this so what is the impact of the server in the Current Host server SQL12CLUB when I click the Cluster Name under Failover Cluster Manager..what things are hosted on the SQL12CLUB? yes you are right there is a role named ISQLAPPAG1 and this role is hosted on SQL12CLUA..there was nothing in Windows 2008R2 clustering I think? I only wondered

as you said, SQL12CLUA is active node and SQL12CLUB is passive node...
Benjamin VoglarIT ProCommented:
If something go wrong with SQL12LUA, server SQL12CLUB will automatically take ownership of your role. That meen he will be the owner of the ROLE and CLUSTER DISKS.

If you have to restart NODE A, you have to move the role first. Right click on the role and then select MOVE - SELECT NODE (OR BEST POSIBLE NODE).
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.