Share via

Onpremise Linked service with Managed Identity

rajendar erabathini 616 Reputation points
2021-05-19T08:12:06.36+00:00

Hi - Can we create linked service to Onpremise SQL server using Managed Identity instead of Sql/windows authentication. I need to use the linked service in ADF/Data pipeline in Synapse workspace.

thanks

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments
Answer accepted by question author
  1. PRADEEPCHEEKATLA 91,656 Reputation points Moderator
    2021-05-19T10:50:23.287+00:00

    Hello @rajendar erabathini ,

    Thanks for the question and using MS Q&A platform.

    Unfortunately, you cannot create linked service to on-premise SQL server using Managed Identity.

    Reason: Azure Active Directory is not supported for on-premise SQL Server.

    In ADF/Synapse you can create linked service to on-premise SQL server using Sql/windows authentication.

    97798-image.png

    Hope this helps. Do let us know if you any further queries.

    ------------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.