Forum Discussion
ADF not connecting Azure SQL
Hi there,
I'm trying to connect ADF linked service to Azure SQL DB using service principle so i dont need to use userid or password. However i think im missing something. I think there could be VNET inbetween. I followed instructions, may be in im missing something and ADF is not connecting. I feel I have set up both the ends correctly, however there is something in the middle that seems to be stopping.
Thanks
4 Replies
your setup seems correct at the SQL and service principal level, the connection is failing because ADF cannot reach the SQL server network endpoint. Since you are using a Managed VNet IR, ensure the SQL Server has either public access enabled with allow Azure Services turned on, or a private endpoint from ADF created and approved. If using private endpoint, verify its status is Approved and that a Private DNS Zone privatelink.database.windows.net is linked to the Managed VNet. Until the network path is open, ADF will not be able to resolve the server name and the connection will fail, regardless of credentials.
im super confused. the below private end point approval error states im requesting access from different tenant id. which im not. There is only 1 subscription which has different RG, and Azure SQL and ADF are under the same subscription.
Hi AJAJ , hope you are doing well. We are sorry to hear your isse, but this is forum is related to Fabric related issues only. For Azure issues, please reach Questions - Microsoft Q&A for further assistance.
If you have any fabric related issues/concerns/queries, please feel free to create a new post here in the community. We are always happy to help.
Thank you.
