Choose Servers to Configure (Configure Database Mirroring Security Wizard)

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 SQL Server 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

Options

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).

See Also

Database Properties (Mirroring Page)
Database Mirroring (SQL Server)