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