Edit

Configure Database Mirroring Security Wizard: Service Accounts

  • Article

Applies to: SQL Server

When using Windows Authentication, if the server instances use different accounts, specify the service accounts for SQL Server. These service accounts must all be domain accounts (in the same or trusted domains).

If all the server instances use the same domain account or use certificate-based authentication, leave the fields blank. Simply click Finish, and the wizard automatically configures the accounts based on the account of the current wizard.

Important

If the database mirroring endpoints of the server instances are configured to use certificates, you must leave the service account fields empty.

To configure database mirroring by using SQL Server Management Studio

Options

Principal
Specify the service account of the principal server instance. Enter the domain name in upper case:

DOMAINNAME\username

Mirror
Specify the service account of the mirror server instance. Enter the domain name in upper case:

DOMAINNAME\username

Witness
Specify the service account of the witness server instance. Enter the domain name in upper case:

DOMAINNAME\username

See Also

Database Properties (Mirroring Page)
Start Database Mirroring Monitor (SQL Server Management Studio)
Database Mirroring (SQL Server)
Set Up Login Accounts for Database Mirroring or Always On Availability Groups (SQL Server)