Enabling communication traces in C# application for Azure AD authentication with SQL DB using token-based mechanism with Multi-factor authentication (MFA)

SQL server security team presents a code sample ( as VS project) allowing to enable communication traces for ADAL managed library used to support Universal Authentication with MFA for SQL DB ( see also Azure AD authentication extensions for Azure SQL DB and SQL DW tools). The ADAL traces help to troubleshoot communication issues related… Read more

Token-based authentication including Multi-factor auth (MFA) for Azure SQL DB using Azure Active Directory (AD)

SQL server security team presents an application solution for token-based authentication with multi-factor (MFA) support for SQL DB using Azure AD auth. The zip file attached below with the codes sample and a Readme doc present more details on this topic. For additional information see also Azure AD authentication extensions for Azure SQL DB and SQL DW tools. For further… Read more

Azure samples for Azure AD .Net WebApi using Azure AD “on-behalf of token” to connect to SQL DB and SQL DW

The C# code samples attached in the zip file below present a solution for the front-mid tier architecture allowing client applications to use individual Azure AD user credentials to connect to SQL DB/DW using mid-tier WEB app “on-behalf of token” obtained from Azure AD by redeeming individual user’s access token. This solution represents a standard… Read more

Token-based authentication support for Azure SQL DB using Azure AD auth

SQL Server security team would like to announce token based authentication support for Azure SQL DB V12 authentication using Azure Active Directory (AD). Currently we support two authentication methods: Azure AD user/password and Azure AD integrated authentication supporting Windows credentials ( see https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/ ). The new token-based authentication method allows middle-tier services to obtain a… Read more

Examples of some connection errors for Azure Active Directory Authentication

Mirek SztajnoLast updated on 09/28/15 Examples of some connection errors for Azure Active Directory Authentication with Azure SQL DB V12 (*) Please note that this table does not represent a complete sample of connection errors for Azure AD authentication     and will be extended based on new connection errors experienced by end-users    Error Message  Reason  Action Error: 18456… Read more

Azure Active Directory Authentication – troubleshooting potential connectivity issues

To troubleshoot potential connectivity issues for Azure AD authentication featureavailable for public preview (see https://azure.microsoft.com/documentation/articles/sql-database-aad-authentication/ ),the “User Troubleshooting Guide”  document was attached UsersTroubleshootingGuideForAzureADAuthentication.zip… Read more