This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 70%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
hi,
i have a PaaS SQL on which i want to make access only AD backed.
if i select option in the screenshot, i think i will achieve it.
but then I still have usecase where i have to give access to ADF (managed identity), App reg access to my SQL server. will it still be possible to do that?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Thanks, Alberto
Hi @Prasad, Rakesh ,
Just to add one more point to Alberto's answer, when you enable AAD on Azure SQL server, only SQL authentication will be disabled.
and as he mentioned, you can still use- system/user assigned managed identity, service principles
You can use Managed Identity (MI) to control ADF’s access to any data sources which support Azure AD based authentication. This is considered to be the most secured and recommended way of authenticating ADF with cloud systems.
You won't have any problems to use managed identity with an Azure SQL that allows only AD connections.