ADF not connecting Azure SQL

[AJAJ]

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

[v-hashadapu]

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.

[AJAJ]

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.

[Vinodh247]

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.

[AJAJ]

Thanks @Vinodh247 

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