When creating a linked server over a private endpoint from a Azure SQL Managed Instance to an Azure SQL DB database there’s one very important think to keep in mind. The username will not be in the “normal” format. When creating a linked server between an MI and SQL DB you need to append “@servername” to the end of the username in the linked server properties.
If your SQL DB servername was “devsql1” and you were using a login of “link1” to connect to the server you would need to use the username of “link1@devsql1” when you create the linked server on the Azure SQL Managed Instance.
DennyContact the Author | Contact DCAC