MSSQLSERVER_41976

Applies to: Azure SQL Managed Instance

Details

Attribute Value
Product Name SQL Server
Event ID 41976
Event Source MSSQLSERVER
Component SQLEngine
Message Text Connection with availability group '%.*ls' on the server with endpoint '%.*ls' cannot be established as it is not responding. Possible causes could be nonexistence of availability group or distributed availability group on the partner server, incorrectly specified names or configuration parameters. Please check the log file on the partner server for the exact error cause.

Explanation

The connection with the availability group on SQL Server can't be established because the availability group isn't responding.

This could be due to the following reasons:

  • The availability group doesn't exist on the primary replica.
  • The distributed availability group doesn't exist on the secondary replica.
  • Configuration parameters, such as instance names, have been specified incorrectly.

User action

Validate the names of the SQL Server instance, availability group, and distributed availability group are correct, and match the names visible on Azure SQL Managed Instance. Confirm scripts have been executed on the correct replica using the correct parameters.