How to connect Azure Managed Instance in Azure Linked service RRS feed

  • Question

  • I am trying to make the "Managed Instance" as destination in Azure Data Factory(copy data). But, I couldn't see any option to select "Managed Instance" in Linked service.

    I tried selecting "Azure SQL Database" and entered the managed instance credentials, obviously it didn't work. Is there a workaround for this?

    Is there a way to make managed instance as my data store ?

    Monday, August 6, 2018 8:41 AM

All replies

  • Is that an azure sql database under vnet? If so, you need install a selfhosted IR to access your managed instance.
    Tuesday, August 7, 2018 4:37 AM
  • But in "New Linked Service" tab, there is no option to select 'Managed Instance". Because only after choosing it we will be asked to install IR. 
    Tuesday, August 7, 2018 5:21 AM
  • I think you could just try "Azure SQL Database". Input the correct database name, server name and credentials. And install/choose an IR  in "Connect via integration runtime" field.

    If you hit any error when testing connection, please share the screenshot and error message.

    Tuesday, August 7, 2018 6:22 AM