**[Update 1]**

I could make it work using the following connection string

```
Server=tcp:mydatabaseserver.database.windows.net,1433;Initial Catalog=mydbname

```

and implementing an interceptor as mentioned in [this article](https://gasior.net.pl/blog/passwordless-connection-string-to-azure-sql-database-from-net-core-api/).

This proves that Azure is correctly configured, and the problem is somewhere in the application (maybe a missing package?).

Anyway, I would still like to be able to change the connection string and switch between AAD authentication and sql authentication, without additional logic in the application.

**[/Update 1]**

I'm using **EF Core 3.1.4** on an Azure WebApp, and I would like to use the Azure AD identity assigned to the application for authentication, but I run into the following exception:

```
ArgumentException: Invalid value for key 'authentication'.
Microsoft.Data.Common.DbConnectionStringBuilderUtil.ConvertToAuthenticationType(string keyword, object value)

```

This is the connection string:

```
{
    "ConnectionStrings": {
        "Admin": "Server=tcp:mydatabaseserver.database.windows.net,1433;Initial Catalog=mydbname;Authentication=Active Directory Integrated"
    }
}

```

I initialize the context using the following code:

```cs
var connectionString = this.Configuration.GetConnectionString("Admin");
services.AddDbContext<NetCoreDataContext>(builder => builder.UseSqlServer(connectionString));

```

The `Microsoft.Azure.Services.AppAuthentication` package is also imported (version **1.5.0**)