Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Service Accounts (Configure Database Mirroring Security Wizard)

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 note 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

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.