| title | MSSQLSERVER_41986 | |
|---|---|---|
| description | MSSQLSERVER_41986 | |
| author | djordje-jeremic | |
| ms.author | djjeremi | |
| ms.date | 12/06/2024 | |
| ms.service | sql | |
| ms.subservice | supportability | |
| ms.topic | reference | |
| helpviewer_keywords |
|
[!INCLUDE SQL MI]
| Attribute | Value |
|---|---|
| Product Name | [!INCLUDEssNoVersion] |
| Event ID | 41986 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Message Text | Azure SQL Managed Instance link creation failed because either connection to SQL Server failed, or the server did not respond after a prolonged period of time. Verify the network connectivity and firewall rules between SQL Server and Managed Instance are properly configured and retry again. |
The link failed to create because either:
- the connection to the secondary replica failed
- the server didn't respond after a prolonged period of time
Error 41986 could be due to network connectivity issues or incorrectly configured firewall rules during the link creation process, or after the link is already created.
Verify that network connectivity was successfully established between SQL Server and Azure SQL Managed Instance, and that firewall rules are correctly configured, as described in Configure network connectivity. Retry the operation after connection has been verified successfully.