MicrosoftHello @erinstellato
Is AAD plus with 2FA enabled (With AAD only, your https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-linked-server?view=sql-server-ver16 , works fine)
With https://learn.microsoft.com/en-us/azure/active-directory/authentication/concept-mfa-howitworks, you need put your put your Login / Pass and Use Microsoft Authenticator interactively
For https://learn.microsoft.com/en-us/azure/azure-sql/database/active-directory-interactive-connect-azure-sql-db?view=azuresql: Authentication=Active Directory Interactive;
For https://learn.microsoft.com/en-us/sql/connect/odbc/using-azure-active-directory?view=sql-server-ver16 Authentication=ActiveDirectoryInteractive; (Min Version 17.1)
The error is clear: The value of Authentication parameter is not valid
This would be the equivalent of SSMS connection wizard: "With MFA":
