| title | Service Accounts (Configure Database Mirroring Security Wizard) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 05/17/2016 | |
| ms.prod | sql | |
| ms.prod_service | high-availability | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology | high-availability | |
| ms.tgt_pltfrm | ||
| ms.topic | conceptual | |
| f1_keywords |
|
|
| ms.assetid | d58d8f93-7888-4d66-af4d-969ef6a2dbee | |
| caps.latest.revision | 34 | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | craigg |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] When using Windows Authentication, if the server instances use different accounts, specify the service accounts for [!INCLUDEssNoVersion]. 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
-
Establish a Database Mirroring Session Using Windows Authentication (SQL Server Management Studio)
-
Start the Configuring Database Mirroring Security Wizard (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
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)