monitor
#monitor#35250

35250

Product Name Event ID 35250 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HADR_PRIMARYNOTACTIVE Message Text The connection to the primary r

Product Name

Event ID

35250

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

HADR_PRIMARYNOTACTIVE

Message Text

The connection to the primary replica isn’t active. The command can’t be processed.

This error occurs when you try to join secondary databases to an Always On availability group

but can’t connect to the endpoint.

Run the following query to discover the endpoint.

Expand table

Note

Run all the following steps on both the primary replica and the problematic secondary

replicas.

SELECT tep.name
AS
EndPointName,
sp.name
AS
CreatedBy,