Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #192: MSIS7068-Access denied error message connecting to Azure SQL Database using AAD

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Mar 17, 2022

Today, we worked on a case that our customer faced the following error message: "MSIS7068: Access denied. (System.Data)" trying to connect to the Azure SQL Database database using Azure Active Directory Integrated Authentication.

 

After some investigations we found that this issue is related that our customer has not O365 license assigned to the user. O365 user license is required for AD authentication to work.

 

Enjoy!

Updated Nov 09, 2023
Version 2.0
  • AnthonyEY's avatar
    AnthonyEY
    Copper Contributor
    Dec 14, 2022

    Hey,

    There are many types of O365 licenses, Office E3 vs Office E5, EMS E3 vs E5 as examples and within each of those there are many sub product licenses.

    Which one are you referring to that solved your problem here?

    Thanks.