SQL Server MFA auth broken and MDS DDEX connections broken - Invalid value for key 'authentication

ToddEvansHome commented 1 year ago

Describe what is not working as expected.

Provide steps to reproduce

I am connecting to Azure SQL DB with MFA.

Data Source: Microsoft SQL Server
Data Provider: Microsoft SqlClient Data Provider for SQL Server
Authentication: Active Directory Interactive Authentication
User Name: ###
Database Name: ###
Press Test Connection: "Test connection succeeded"
Press Advanced: Data Source=####.database.windows.net;Initial Catalog=###;User ID=###;Authentication=ActiveDirectoryInteractive
Press "OK": "Unable to add connection, maybe the provider is not supported: Invalid value for key 'authentication'.

When I try the Add Custom Connection with Azure SQL DB using the above connection string I get the following exception

System.ArgumentException: Invalid value for key 'authentication'.
   at SqlAuthenticationMethod System.Data.Common.DbConnectionStringBuilderUtil.ConvertToAuthenticationType(string keyword, object value)
   at SqlAuthenticationMethod System.Data.SqlClient.SqlConnectionString.ConvertValueToAuthenticationType()
   at new System.Data.SqlClient.SqlConnectionString(string connectionString)
   at DbConnectionOptions System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(string connectionString, DbConnectionOptions previous)
   at DbConnectionPoolGroup System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, ref DbConnectionOptions userConnectionOptions)
   at void System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at void System.Data.SqlClient.SqlConnection.set_ConnectionString(string value)
   at new System.Data.SqlClient.SqlConnection(string connectionString, SqlCredential credential)
   at Tuple<bool, Version> EFCorePowerTools.Helpers.ReverseEngineerHelper.HasSqlServerViewDefinitionRightsAndVersion(string connectionString)
   at void EFCorePowerTools.Handlers.ReverseEngineer.ReverseEngineerHandler.VerifySQLServerRightsAndVersion(ReverseEngineerOptions options)
   at async Task EFCorePowerTools.Handlers.ReverseEngineer.ReverseEngineerHandler.ReverseEngineerCodeFirstAsync(Project project, string optionsPath, bool onlyGenerate, bool fromSqlProj)