Hello, I've successfully connected my umbraco web app to its db in Azure using AzureKeyVault, following the great instructions here: https://docs.umbraco.com/umbraco-cms/extending/key-vault

However, I am having problems getting the solution to run locally when I remove the connection string value from AppSettings.json.

My Program.cs:

var builder = Host.CreateDefaultBuilder()
.ConfigureUmbracoDefaults()
.ConfigureWebHostDefaults(webBuilder =>
{
    webBuilder.UseStaticWebAssets();
    webBuilder.UseStartup<Startup>();
})
.ConfigureLogging(x => x.ClearProviders())
.ConfigureAppConfiguration((ctx, builder) =>
{

    var keyVaultEndpoint = "https://<<kv-myVaultAddress>>.vault.azure.net";

    if (!string.IsNullOrEmpty(keyVaultEndpoint) && Uri.TryCreate(keyVaultEndpoint, UriKind.Absolute, out var validUri))
    {
        builder.AddAzureKeyVault(validUri, new DefaultAzureCredential());
    }
    builder.AddJsonFile("appsettings.json", false, true);

});  var host = builder.Build(); host.Run();

Then in appsettings I add:

  "AzureKeyVaultEndpoint": "https://<<myVaultAddress>>.vault.azure.net",

When I inspect the value of config in Startup.cs it has definitely pulled in the connection string from the azure vault

However, when the build completes I get the blank umbraco environment you would get with a fresh install, so it's as if the connection string isn't registered.

Has anyone come across this? I wondered if it is anything to do with the naming convention? Ie in appsettings you'd normally have:

"ConnectionStrings" : { "umbracoDbDSN" : "string"}

which gets read as ConnectionStrings.umbracoDbDSN