monitor
#monitor#41977

41977

Product Name Event ID 41977 Event Source MSSQLSERVER Component SQLEngine Message Text Connection with availabili

Product

Name

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.

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.

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.

Expand table