| title | Include Witness Server (Configure Database Mirroring Security Wizard) | |
|---|---|---|
| description | Describes the 'Include Witness Server' page of the 'Configure Database Mirroring Security' Wizard within the SQL Server Management Studio (SSMS) GUI. | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| ms.date | 03/07/2017 | |
| ms.service | sql | |
| ms.subservice | database-mirroring | |
| ms.topic | conceptual | |
| f1_keywords |
|
[!INCLUDE SQL Server] 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