Creating a Linked Server from Managed Instance to Azure SQL DB

Published On: 2021-05-18By:

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

Contact the Author | Contact DCAC

3 responses to “Creating a Linked Server from Managed Instance to Azure SQL DB”

  1. Timothy McAliley says:

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

    • Denny Cherry says:

      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.

  2. Thank you very much, very helpful!

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
American Business Award 2021 Gold    American Business Award 2021 Bronze    FT Americas’ Fastest Growing Companies 2021   INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award
FT Americas’ Fastest Growing Companies 2020       Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award
Share via
Copy link