ALTER ALWAYS ON ENDPOINT


--Always On: Modify HADR_Endpoint Port
--Skip to end of metadata
--SSMS: Connect to the instance where you want to modify the listener
--Execute the following TSQL-Satement to modify the TCP Port:

ALTER ENDPOINT [Hadr_endpoint]
    STATE=STARTED
    AS TCP (LISTENER_PORT = <enterPortNumberHere>, LISTENER_IP = ALL)
    FOR DATA_MIRRORING (ROLE = ALL, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM AES)
       --SSMS: Connect to the primary instance to update the AvailabiliityGroup Endpoint URL
       --Execute the following TSQL-Statement:
ALTER AVAILABILITY GROUP []
MODIFY REPLICA ON ''
WITH (endpoint_url = 'TCP://:')
       --Check, if Synchronization is running properly




Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server