Does linked service in data factory supports AD Authentication to connect to Azure SQL DB. please provide an example if it supports and any alternative if AD Auth is not supported?

Ranjith Kumar Bommineni 41 Reputation points
2022-09-07T07:36:01.35+00:00

Does linked service in data factory supports AD Authentication to connect to Azure SQL DB. please provide an example if it supports and any alternative if AD Auth is not supported?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,761 questions
0 comments No comments
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 27,656 Reputation points Microsoft Employee
    2022-09-07T20:13:07.963+00:00

    Hello @Ranjith Kumar Bommineni ,

    Welcome to the MS Q&A platform.

    Azure SQL DB linked service won't support Azure AD authentication.

    it only supports the below authentication types

    1) SQL authentication
    2) System Assigned managed identity
    3) User Assigned managed identity
    4) Service principals

    Here is the document explaining each authentication type. If you have any further questions, please let us know

    238754-image.png


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful