Sql database in Fabric

[SaharRad]

Hi everyone,

I’m trying to connect an ODBC data source to a SQL Database in Microsoft Fabric, but I’m facing this error:

Microsoft ODBC Driver for SQL Server Version 18.04.0001

Running connectivity tests...

Attempting connection

[Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot open server

Here’s what I’ve done so far:

1. Tried various authentication methods, including Microsoft Entra ID Password Authentication, but the connection still fails. In this method, I provided my login ID and password, but the issue persists.
2. Confirmed that my email is added to the SQL database security settings in Microsoft Fabric.
3. Verified the server name matches the connection string provided in Fabric.

Despite trying multiple configurations, the connection test continues to fail. Is there something I might be missing in the setup, or are there additional steps to enable external ODBC connections to Microsoft Fabric SQL databases?

Any advice or guidance would be greatly appreciated!

Thank you in advance!

When I tried to access the Azure portal using the business email account I created specifically for using Fabric, I encountered this error. It might be related to the issue I had when connecting to the server in the SQL database within Fabric.

[eileen_iTalent]

Hello @SaharRad 

We have recently created a new Databases forum on the Fabric Community where you can ask your questions about SQL Database.  Please repost your question to this forum:  https://community.fabric.microsoft.com/t5/Databases-preview-forums/ct-p/databases

Thank you,

Eileen