Solved

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

Posted on 2016-11-10
6
67 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 50

Accepted Solution

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

Expert Comment

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

Open in new window

0
Technology Partners: 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!

 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 250 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

Industry Leaders: 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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
A procedure for exporting installed hotfix details of remote computers using powershell
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

707 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