| title | Principal Server Instance (Configure Database Mirroring Security Wizard) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/07/2017 | |
| 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 | 58af27d7-c5dd-4669-be6b-b472bc2c8ef4 | |
| caps.latest.revision | 36 | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | craigg |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] Use this page to specify information about the server instance of the principal database. The principal database is the copy of the database that begins the mirroring session. After the session has begun, the principal database is the copy of the database that accepts user changes. (When a failover occurs, the principal and mirroring roles are swapped; therefore, the initial principal database might not remain the principal database.)
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 server instance
Because database mirroring in [!INCLUDEssManStudioFull] is always configured from the principal server, the current server instance is always the principal server instance.
Listener Port
The behavior of this option depends on whether the mirroring endpoint exists for this server instance, as follows:
-
If the listener port does not exist for this server instance, port number 5022 is displayed in the Port text box. You can use any available port number, such as, 7022.
-
When the mirroring endpoint already exists, the port number from the endpoint is displayed. If you need to change the port, use an ALTER ENDPOINT command. For more information, see ALTER ENDPOINT (Transact-SQL).
Note
A port number is required.
Endpoint name
If the mirroring endpoint exists for this server instance, the endpoint name is displayed here. If the endpoint does not exist, you can specify the name of the endpoint.
Encrypt data sent through this endpoint
By default, encryption is enabled. When enabled, encryption is required (not merely supported) and uses the default values for all of the encryption options. For more information, see CREATE ENDPOINT (Transact-SQL).
To disable encryption, clear the check box. To re-enable encryption, select the check box.
The Database Mirroring Endpoint (SQL Server)
Database Properties (Mirroring Page)
Create a Database Mirroring Endpoint for Windows Authentication (Transact-SQL)
Start Database Mirroring Monitor (SQL Server Management Studio)
Database Mirroring (SQL Server)