| title | Choose Servers to Configure (Configure Database Mirroring Security Wizard) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | high-availability | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| ms.assetid | 59e23ff3-d7ee-4e32-9629-0b54d3a258f7 | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | craigg |
Use this page to specify which server instances you want to configure now. You must select at least one server instance before continuing the wizard.
If you clear the check box for a server instance, the wizard will not make any changes to it. The wizard, however, will ask you to enter information about that instance and save this information as part of the configuration of the other server instances. For example, if you clear the check box for the witness server instance, the wizard will ask you to enter the [!INCLUDEssNoVersion] service account of the witness because a login for that account must be created as part of the security configuration saved at the principal and mirror server instances.
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)
Principal server instance
Select to configure security for the principal server.
Mirror server instance
Select to configure security for the mirror server.
Witness server instance
Select to configure security for the witness server (if present).
Database Properties (Mirroring Page)
Database Mirroring (SQL Server)