This change extends the implementation of the underlying TDS protocol to support Azure Active Directory authentication, which enables the customers to run the advanced connectivity tests using AAD auth on both SQL MI and SQL DB. Every step of the login process is logged so it can be easily noticed where the connection is failing.
It also extends the basic checks to support AAD auth.
Supported types of AAD logins are: username password, integrated, interactive, managed identity (system and user managed). Both ADAL and MSAL are supported as libraries for JWT token acquisition.
Extended MSAL and ADAL logging is enabled, providing the customer with details when token is being acquired.
This change extends the implementation of the underlying TDS protocol to support Azure Active Directory authentication, which enables the customers to run the advanced connectivity tests using AAD auth on both SQL MI and SQL DB. Every step of the login process is logged so it can be easily noticed where the connection is failing.
It also extends the basic checks to support AAD auth.
Supported types of AAD logins are: username password, integrated, interactive, managed identity (system and user managed). Both ADAL and MSAL are supported as libraries for JWT token acquisition.
Extended MSAL and ADAL logging is enabled, providing the customer with details when token is being acquired.