[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2016-11-10
6
Medium Priority
?
78 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 29

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 52

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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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.

650 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