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.