MSSQLSERVER_41977
Applies to: 
Azure SQL Managed Instance
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 41977 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Message Text | Connection with availability group '%.*ls' on the server with endpoint '%.*ls' is established, but there is no response from the target database. Possible causes could be errors with creating a database 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
Although the connection with the availability has been established successfully, there's no response from the target database, and the link can't be created.
This could be due to the following reasons:
- The database failed to create on the secondary replica.
- Configuration parameters have been specified incorrectly.
User Action
Validate the names of the database, 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.