How to set IsAzureADOnlyAuthenticationEnabled to false in Azure Sql Server?

[yudielcurbelo]

Is there a way to set IsAzureADOnlyAuthenticationEnabled to false in Azure Sql Server?

[davidfowl]

We set it here:

aspire/src/Aspire.Hosting.Azure.Sql/AzureSqlExtensions.cs

Line 221 in c0ff16d

IsAzureADOnlyAuthenticationEnabled = true,

You can override this yes but what are you trying to do?

[yudielcurbelo]

A valid value is either true or false. I just want the SQL Server to be also accesible using Username and Password.

[davidfowl]

Where are you setting up the username and password?

[yudielcurbelo]

I was planing on using the Manage Identity for the App connection and then setting up the username and password manually in azure to be able to connect directly into the database using my computer. I did not find any way to set up the username and password.

[yudielcurbelo]

You were right about what a valid configuration is. In order to be able to disable it, a username and password should be provided.

    var sqlServer = builder.AddAzureSqlServer("sql-server")
    .ConfigureInfrastructure(infra =>
    {
        var sql = infra.GetProvisionableResources().OfType<SqlServer>().Single();
        sql.Administrators.IsAzureADOnlyAuthenticationEnabled = false;
        sql.AdministratorLogin = "admin";
        sql.AdministratorLoginPassword = "password";
    });

[davidfowl]

I'd recommend something like this:

var user = builder.AddParameter("sqlUser");
var pwd = builder.AddParameter("sqlPassword", secret: true);

var sqlServer = builder.AddAzureSqlServer("sql").ConfigureInfrastructure(infra =>
{
    var sql = infra.GetProvisionableResources().OfType<SqlServer>().Single();
    sql.Administrators.IsAzureADOnlyAuthenticationEnabled = false;

    sql.AdministratorLogin = user.AsProvisioningParameter(infra);
    sql.AdministratorLoginPassword = pwd.AsProvisioningParameter(infra);
})
.AddDatabase("db");

[yudielcurbelo]

This works great. Thank you.