Saturday 29 April 2017

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

No comments:

Post a Comment