Fabric SQL Connection End Point

Hello VNallagatla,

Fabric Data Warehouse currently does not support traditional SQL Server authentication (for example, sa, SQL logins, or CREATE USER ... WITH PASSWORD).

Authentication is based on Microsoft Entra ID (Azure AD), so there isn't a master SQL login that can be created or managed like in SQL Server or Azure SQL Database.

If your external application only supports Host + Port + Username + Password (SQL authentication), there isn't a native way to connect it directly to a Fabric Data Warehouse.

Your options are:

• Use Microsoft Entra ID authentication, if the application supports it (interactive login, service principal, or managed identity).
• Introduce an intermediate layer, such as Azure SQL Database, SQL Server, or another supported service that the legacy application can authenticate to, and then synchronize or expose the Fabric data as needed.
• Check whether the application vendor offers a newer connector or driver that supports Microsoft Entra ID authentication for SQL endpoints.

Unfortunately, there isn't a supported way to obtain an sa account or create SQL-authenticated users in Fabric Data Warehouse.

Best regards,
Omkar Shinde
Microsoft Fabric Enthusiast | Power BI Consultant

💡 If you found this response helpful, please consider giving it a Kudos.
✅ If this resolves your question, please mark it as the Accepted Solution to help others in the community.