Not able to connect FabricWarehouse via ADF

[Rohitb]

I was previously able to connect to Fabric Warehouse 'Warehouse1' via an ADF Pipeline using a Service Principal, and I could also access it through SSMS. However, I'm now facing an issue where I can't connect to the warehouse anymore. The error I'm receiving through ADF is :

ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'Server1.datawarehouse.fabric.microsoft.com', Database: 'Warehouse1Id', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.,Source=Microsoft.DataTransfer.Connectors.MSSQL,''Type=Microsoft.Data.SqlClient.SqlException,Message=Login failed for user '<token-identified principal>'.,Source=Framework Microsoft SqlClient Data Provider,'.

Does anyone know why this issue has occurred suddenly? Could any settings have been updated that might have caused this? Appreciate any help in advance!

[v-ssriganesh]

Hi @Rohitb,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @Rohitb,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh · Accepted solution]

Hi @Rohitb,
Thank you for reaching out to the Microsoft Fabric Forum Community.

We understand that you are experiencing an issue connecting to Fabric Warehouse 'Warehouse1' via an ADF Pipeline using a Service Principal. Here are a few troubleshooting steps that might help resolve the issue:

• Verify that the Service Principal used for the connection has the necessary permissions and that its credentials are up to date.
• Check for any network-related issues that might be preventing the connection. This includes ensuring that the network configuration has not changed.
• Confirm that the Fabric Warehouse 'Warehouse1' is online and accessible. Sometimes, the database might be undergoing maintenance or experiencing downtime.
• Check that the connector being used in the ADF Pipeline is correctly configured and up to date.

• If there have been any recent changes to the ADF Pipeline, the Fabric Warehouse, or the network configuration that might have caused this issue.

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-ssriganesh]

Hi @Rohitb,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.