?
Solved

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

Posted on 2016-11-10
6
Medium Priority
?
71 Views
Last Modified: 2016-11-14
Heyas,

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.
0
Comment
Question by:Zack
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 28

Expert Comment

by:Dr. Klahn
ID: 41883351
These two sites discuss the issue, which apparently is not as simple as it should be.

https://msdn.microsoft.com/en-us/library/ms178655.aspx

http://www.sqlservercentral.com/Forums/Topic548461-146-1.aspx
0
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 1000 total points
ID: 41883420
A Cluster doesn't have a witness.
The witness server is used for Mirroring solutions.
0
 
LVL 13

Expert Comment

by:Máté Farkas
ID: 41883904
Maybe this one:
select * from sys.database_mirroring_withnesses

Open in new window

0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 1000 total points
ID: 41885325
if you meant  clustered Witness File Share location   -- quorum

you can check this from the Cluster Manager Console
Or Using PS script:
Get-ClusterQuorum
Get information about the quorum configuration of a failover cluster.
0
 

Author Comment

by:Zack
ID: 41885941
Heyas,

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.
0
 

Author Closing Comment

by:Zack
ID: 41885952
Found it myself in Database -> Properties -> Mirroring thank you for the assistance.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question