Dear Dynamicweb,
We are trying to setup hosting in Azure and would like to use Manage Identity for accessing the sql database, but it does not seem to work as Dynamicweb is using "System.Data.SqlClient" and not "Microsoft.Data.SqlClient" which does support connecting to the database.
Please find article here: https://techcommunity.microsoft.com/t5/azure-database-support-blog/lesson-learned-396-fixing-invalid-value-for-key-authentication/ba-p/3869222 and another guide her: https://blog.novanet.no/passwordless-connectionstring-to-azure-sql-database-using-managed-identity/
Best regards, Anders