Database Mirroring login attempt by user ‘Domain\Login’ failed with error: ‘Connection handshake failed. The login ‘Domain\Login’ does not have CONNECT permission on the endpoint. State 84.’. [CLIENT: xx.xx.xx.xxx]

While configuring database mirroring we encountered below error message with GUI and in SQL Server Error Log   GUI Error:  Error : Database Mirroring login attempt by user ‘Domain\Login’ failed with error: ‘Connection handshake failed. The login ‘Domain\Login’ does not have CONNECT permission on the endpoint. State 84.’. [CLIENT: xx.xx.xx.xxx] Reason : Normally this error popup […]

Monitoring Database Mirroring Latency

DECLARE @MirroredDBToTest sysname SET @MirroredDBToTest = DB_NAME() DECLARE @MirroringResults TABLE (database_name sysname, role int, mirroring_state int, witness_status int, log_generation_rate int, unsent_log int, send_rate int, unrestored_log int, recovery_rate int, transaction_delay int, transactions_per_sec int, average_delay int, time_recorded datetime, time_behind datetime, local_time datetime) INSERT INTO @MirroringResults EXEC msdb..sp_dbmmonitorresults @database_name = @MirroredDBToTest SELECT DATEDIFF(S,time_behind, time_recorded) AS Latency FROM @MirroringResults

The server network address “TCP://SQL Server:5022” cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

Error : The server network address “TCP://SQL Server:5022” cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418) To over come the issue follow the below steps. Drop the Mirroring Endpoints from Principal and Secondary. select […]

Monitoring Database Mirroring

Couple of days back I was working for a client on creating a database mirroring monitor report to show how log is being sent to DR in last hour or so. How much log is left to be sent based on the send rate and how long will it. Stored Procedure sp_dbmmonitorresults in msdb database gives all […]