| title | Include Witness Server (Configure Database Mirroring Security Wizard) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/07/2017 | |
| ms.prod | sql | |
| ms.prod_service | high-availability | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology | high-availability | |
| ms.tgt_pltfrm | ||
| ms.topic | conceptual | |
| f1_keywords |
|
|
| ms.assetid | f04b38a4-f4e2-4d4c-bdac-7cc70e5a5684 | |
| caps.latest.revision | 32 | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | craigg |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] Use this page to specify whether you want to include a witness server in this security configuration for database mirroring.
To configure database mirroring by using SQL Server Management Studio
-
Establish a Database Mirroring Session Using Windows Authentication (SQL Server Management Studio)
-
Start the Configuring Database Mirroring Security Wizard (SQL Server Management Studio)
Yes
Click to include a witness server instance in the security configuration. The witness is necessary for high-safety mode with automatic failover, which supports automatic failover to the mirror server instance if the principal server instance fails.
No
Click to configure security without a witness.
Database Properties (Mirroring Page)
Database Mirroring (SQL Server)
Database Mirroring Witness