| title | Add replica wizard: Enter Passwords Page for availability groups | |
|---|---|---|
| description | A description of the properties found on the 'Enter Passwords Page' of the 'Add Replica' wizard in SQL Server Management Studio. | |
| ms.custom | seo-lt-2019 | |
| ms.date | 05/17/2016 | |
| ms.prod | sql | |
| ms.reviewer | ||
| ms.technology | high-availability | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| ms.assetid | e69207a0-c5c4-44e4-ae9a-4afbb67251d1 | |
| author | MashaMSFT | |
| ms.author | mathoma |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This help topic describes the options of the Enter Passwords page. This topic applies to the [!INCLUDEssAoAddRepWiz] of [!INCLUDEssCurrent].
If the replicas that you selected on the Specify Replicas page contain databases that have a database master key, the Enter Passwords page appears.
The User databases on this instance of SQL Server grid lists every local user database. The columns are as follows:
Name
Displays the name of a local user database.
Size
Displays the database size, if the size is available to the wizard.
Status
Indicates Password required for databases that have a database master key. After you enter the passwords for the database master keys in the Passwords column, click Refresh. If you entered the passwords correctly, the Status column indicates Password entered.
If the database doesn't have a database master key, the Status column indicates Password not required.
Password
If the Status column indicates Password required, enter the password for the database master key.
Refresh
Click to refresh the grid. This is useful after you enter required passwords.
Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)