Include Witness Server (Configure Database Mirroring Security Wizard)
Applies to: 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)
Options
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.
See Also
Database Properties (Mirroring Page)
Database Mirroring (SQL Server)
Database Mirroring Witness
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for