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
2 |
DROP
ENDPOINT Mirroring
|
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