Creating a Linked Server from Managed Instance to Azure SQL DB

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.

Denny

Share

Share on facebook
Share on twitter
Share on linkedin

3 Responses

  1. I this the same when you create a linked server on SQL MI pointed to an on-prem SQL Server.

    1. This syntax is specific to Azure SQL DB (and the open-source SQL DB solutions). An on-premises SQL Server wouldn’t handle username@servername correctly.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?