Issue with Linked Service Configuration in Azure Data Factory for Cross-Tenant Microsoft Fabric SQL Database

Question

I have two Azure tenants: Tenant ABC and Tenant XYZ. I am using Azure Data Factory (ADF) in Tenant ABC and Microsoft Fabric in Tenant XYZ. 

To establish connectivity between them, I have created a Linked Service in ADF (Tenant ABC) to connect to the SQL Database in Microsoft Fabric (Tenant XYZ). As part of the Linked Service configuration, I have: 

• Provided the Service Principal details of Tenant XYZ in the authentication settings. 
• Granted External User access in Tenant XYZ’s Fabric to ensure proper cross-tenant access. I have two Azure tenants: Tenant ABC and Tenant XYZ. I am using Azure Data Factory (ADF) in Tenant ABC and Microsoft Fabric in Tenant XYZ.  To establish connectivity between them, I have created a Linked Service in ADF (Tenant ABC) to connect to the SQL Database in Microsoft Fabric (Tenant XYZ). As part of the Linked Service configuration, I have: 
  • Provided the Service Principal details of Tenant XYZ in the authentication settings. 
  • Granted External User access in Tenant XYZ’s Fabric to ensure proper cross-tenant access. 

[Image 1]

Issue 

When testing the connection in ADF, I encounter an error. 

[Image 2]

In the Linked Service configuration: 

• Fully Qualified Domain Name (FQDN): I am providing the Data Source part of the connection string from Microsoft Fabric. 

[Image 3]

• Database Name: I am using the given name of the database in Fabric. 

[Image 4]

However, the connection test failed. 

Questions: 

Could there be an issue with the FQDN or Database Name configuration in the Linked Service? 

Are there any additional permissions or settings required in Tenant XYZ’s Fabric environment for successful connectivity? 

 I am not able to upload images. So, I will upload it in the comment section.