Fabric SQL Connection End Point

Hi VNallagatla , completly agree with NandanHegde  about this "Fabric SQL endpoints do not support SQL auth" and just want to save you some time & frustration sharing with you that, not even Fabric SQL Databases permits SQL Authenetication (User/Password); it is NOT because you're not connected as a SA user,  it's just NOT possible to use SQL-base authentication ANYWHARE ... the idea is to rely completly on Entra ID for authentication.

The only workaround is using another service like for instance Data Factory that serves as a "middle tier" as example, that is, connects to the source via  linked services with sql auth. and then sink the data to Fabric using linked services using SPN authentication.  

Another option you may want to explore is On-premises Data Gateway 🤔 If the legacy app is on-prem and can't be modified, the Gateway can broker the Entra ID auth to Fabric while the app connects to the Gateway locally. 

Well, this is the reality of today's Fabric landscape on this area, hope you find the right option for your case .😁🤞 

If you find this informatino useful, give us thumb's up or even better, mark as solution, all the very best