link between SQL Server and an Azure SQL Managed Instance.

Question

I’m facing an issue when trying to establish a link between SQL Server and an Azure SQL Managed Instance. Getting this error.

"statusMessage": "{\"status\":\"Failed\",\"error\":{\"code\":\"ResourceOperationFailure\",\"message\":\"The resource operation completed with terminal provisioning state 'Failed'.\",\"details\":[{\"code\":\"InternalServerError\",\"message\":\"An unexpected error occured while processing the request. Tracking ID: '5634d03d-6390-406f-84ea-cf9d3def20f4'\"}]}}",

Has anyone encountered this problem or found an alternative solution to resolve this without needing to delete the existing linked servers? Any help is appreciated!

Answer 1

Hi there Sammy

Thanks for using QandA plaftorm

I found a similar scenario and a solution to it, can you give it a try and let know if it works for you,

https://learn.microsoft.com/en-us/answers/questions/2125983/error-when-creating-azure-sql-managed-link-from-sq

If this helps kindly accept tthe answer thanks much.