35250

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,