topic Re: ADF not connecting Azure SQL in Pipelines

ADF not connecting Azure SQL

AJAJ — Mon, 12 Jan 2026 15:17:44 GMT

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

Re: ADF not connecting Azure SQL

Vinodh247 — Mon, 12 Jan 2026 16:25:14 GMT

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.

Re: ADF not connecting Azure SQL

AJAJ — Mon, 12 Jan 2026 16:42:57 GMT

Thanks Vinodh247

I dont want to enable public access since its not public access right now. but currently it has selective network.

Re: ADF not connecting Azure SQL

AJAJ — Mon, 12 Jan 2026 17:48:18 GMT

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.

Re: ADF not connecting Azure SQL

v-hashadapu — Mon, 19 Jan 2026 06:46:51 GMT

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.