To get each node in the topology to see each other, you have to identify the endpoints and listener port values to the databases involved in the database mirroring configuration (the principal and mirror). This also activates database mirroring. This process requires altering the database by using either the
SET PARTNER or
SET WITNESS statements within the
ALTER DATABASE command. The Database Mirroring Wizard can also do this step for you, but doing it manually is easy.
We identify the unique endpoint listening port values for each endpoint that are unique within the server. They are port values 1430, 1440, and 1450 in our example.
Remember, you will be doing this after you create the