SQL Script to change a mirror endpoint

 SQL Error

Database Mirroring login attempt failed with error: ‘Connection handshake failed. An OS call failed: (80090311) 0×80090311(No authority could be contacted for authentication.). State 67.’.

 

Solution in my specific scenario.

There was some issue with the port and I wanted to change the Mirroring EndPoint. Here is the script which can be use to changing the Mirroring end point.

-- /* ******************************************** */
-- /* Script to change a mirror endpoint            */
-- /* for mirroring issue with handshake failed    */
-- /* ******************************************** */
drop endpoint <endpointname>
go
CREATE ENDPOINT <endpointname>
    STATE = STARTED
    AS TCP ( LISTENER_PORT = 5022 )
    FOR DATABASE_MIRRORING 
    (ENCRYPTION = DISABLED,ROLE=ALL)
GO