What is End Point in Mirroring? How to create end point in Mirroring? How to Find Port number in Mirroring? How to change port in Mirroring?

 What is End Point in Mirroring?

An endpoint is a network protocol which is used to communicate over the network from one server to another server or we can say one SQL Server instance to another SQL Server Instance . End points will come with in-built security. 

End point runs on a port number, SQL Server supports different types of end points

(i)                  Db mirroring end points

(ii)                service broker end points

(iii)               SOAP end points

(iv)               TCP end points

By default the Database mirroring end points will run on the default port number 5022. 

The default End point Port number Are-

Publisher - 2022

Distributor - 2023

Subscriber - 2024

How to create end point in Mirroring? 

Create endpoint <endpoint name> State=started/stopped/disabled as tcp (listener port=5022/5023) for database_mirroring (role=partner/witness)

How to Find Port number in Mirroring? 

SELECT name, port FROM sys.tcp_endpoints

How to change port in Mirroring?

ALTER ENDPOINT [Mirroring] AS TCP (listener_port = 5023)

Please comment below if missing anything -Jainendra Verma