Creating a Mirror Endpoint in Principal or Mirror Servers
1 | CREATE ENDPOINT Mirroring |
3 | AS TCP (LISTENER_PORT=5022) |
4 | FOR DATABASE_MIRRORING (ROLE=PARTNER) |
Creating an Endpoint for a Witness Server
1 | CREATE ENDPOINT Mirroring |
3 | AS TCP (LISTENER_PORT=7022) |
4 | FOR DATABASE_MIRRORING (ROLE=WITNESS) |
Creating a Login for a Domain User Account for Partner Instances
6 | CREATE LOGIN [SYNTAXHELP\jacob] FROM WINDOWS; |
Grant connect permissions on Endpoint to login account
7 | GRANT CONNECT ON ENDPOINT::Mirroring TO [SYNTAXHELP\jacob]; |
Creating a Mirroring Endpoint that uses an encrypted Certificate
01 | CREATE ENDPOINT Mirroring |
07 | FOR DATABASE_MIRRORING ( |
08 | AUTHENTICATION = CERTIFICATE ServerPriCert, |
09 | ENCRYPTION = REQUIRED ALGORITHM AES, |
Creating a Mirroring Endpoint that uses Windows KERBEROS Authentication
1 | CREATE ENDPOINT mirroring |
3 | AS TCP ( LISTENER_PORT = 7022 ) |
4 | FOR DATABASE_MIRRORING ( |
5 | AUTHENTICATION = WINDOWS KERBEROS, |
6 | ENCRYPTION = SUPPORTED, |
Granting Connect Permission on the Login for Remote Mirroring Endpoint
2 | GRANT CONNECT ON ENDPOINT::Mirroring TO [jacob]; |
Dropping a Mirroring Endpoint
Querying the Mirroring Endpoints
05 | connection_auth_desc AS ConnAuth, |
06 | encryption_algorithm_desc AS Algorithm |
07 | FROM sys.database_mirroring_endpoints; |
09 | name role state connAuth Algorithm |
11 | Mirroring PARTNER STARTED NEGOTIATE NONE |
http://syntaxhelp.com/SQLServer/Mirroring/endpoints