How do you determine what the Witness server is on SQL Server 2012 HA Cluster


As the above title, How do you determine what the Witness server is on SQL Server 2012 HA Cluster?

SQL Server seems to show nothing, anywhere in Windows Server 2012 I can check?

Thank you.
ZackGeneral IT Goto GuyAsked:
Who is Participating?
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
A Cluster doesn't have a witness.
The witness server is used for Mirroring solutions.
Dr. KlahnPrincipal Software EngineerCommented:
These two sites discuss the issue, which apparently is not as simple as it should be.
Máté FarkasDatabase Developer and AdministratorCommented:
Maybe this one:
select * from sys.database_mirroring_withnesses

Open in new window

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Eugene ZConnect With a Mentor Commented:
if you meant  clustered Witness File Share location   -- quorum

you can check this from the Cluster Manager Console
Or Using PS script:
Get information about the quorum configuration of a failover cluster.
ZackGeneral IT Goto GuyAuthor Commented:

My apologies it's a database mirroring witness server. I have found its name of the Witness Server via our network admin where is this configured inside SQL server?

Thank you.
ZackGeneral IT Goto GuyAuthor Commented:
Found it myself in Database -> Properties -> Mirroring thank you for the assistance.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.