Can someone let me know if it's possible to change the authentication method on an Azure Fabric Database to allow for SQL Authentication? I created a SQL account on the database but when I attempt to access the database I get the error message:
Login failed for user 'test2'. Reason: Azure Active Directory only authentication is enabled
However, I don't know how to enable SQL Authentication on Azure Fabric Database.
I agree with @Thom A
To access your Fabric SQL database, you will need to use Microsoft Entra authentication. This means signing in with your Microsoft Entra user account, a service principal, or a group that has been given the right permissions. Make sure the account you're using has the necessary access to the database.
Note: To allow service principals to connect to Fabric and SQL databases, you need to enable the "Service principals can use Fabric APIs" setting in the Fabric tenant settings. For instructions on enabling tenant settings, refer to the Fabric Tenant settings documentation.
Reference: Authentication in SQL database in Microsoft Fabric