Unable to connect to Azure SQL with Fabric Notebook

[Mongia_Cherif]

I am trying to connect to the Azure SQL Database from a Fabric notebook using my credentials, with authentication via Azure Active Directory Universal with MFA.

[suparnababu8 · Accepted solution]

Hello @Mongia_Cherif 

Please check the below pointers

1. Verify that your client IP address is allowed through the Azure SQL Database firewall rules.
2. You can try increasing the connection timeout settings in your connection string.
3. Ensure that you have the latest ODBC drivers installed. Sometimes, outdated drivers can cause connectivity issues.

Please go through below urls, it might helps you to solve your issue.

https://learn.microsoft.com/en-us/fabric/data-factory/connector-azure-sql-database

https://community.fabric.microsoft.com/t5/Fabric-platform/Microsoft-Fabric-connect-to-Azure-Key-Vaul...

Thanks!

[v-menakakota · Accepted solution]

Hi @Mongia_Cherif ,

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

Thank you.

[v-menakakota · Accepted solution]

Hi @Mongia_Cherif ,

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

Thank you.

[v-menakakota · Accepted solution]

Hi @Mongia_Cherif ,

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

Thank you.

[v-menakakota]

Hi @Mongia_Cherif ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.

Make sure that all connection parameters (server, database, username, and authentication) are properly configured.

Ensure that your AAD configuration is properly set up. You might need to register your application in Azure AD and assign the required permissions.
 Ensure that you are using the latest version of the ODBC Driver for SQL Server.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Regards,
Menaka.

[suparnababu8 · Accepted solution]

Hello @Mongia_Cherif 

Please check the below pointers

1. Verify that your client IP address is allowed through the Azure SQL Database firewall rules.
2. You can try increasing the connection timeout settings in your connection string.
3. Ensure that you have the latest ODBC drivers installed. Sometimes, outdated drivers can cause connectivity issues.

Please go through below urls, it might helps you to solve your issue.

https://learn.microsoft.com/en-us/fabric/data-factory/connector-azure-sql-database

https://community.fabric.microsoft.com/t5/Fabric-platform/Microsoft-Fabric-connect-to-Azure-Key-Vaul...

Thanks!