Connection from Azure Data Explorer Web UI to Azure Data Explorer Cluster

Maftuna 1 Reputation point
2022-10-02T20:26:43.647+00:00

I am trying to connect Database in Azure data explorer cluster from Azure Data Explorer web UI, but it is giving an error:

246789-image.png

I have added myself in the permissions in Azure Data explorer cluster, still getting the same problem..

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
487 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 27,566 Reputation points Microsoft Employee
    2022-10-03T22:17:55.117+00:00

    Hello @Maftuna ,

    Welcome to the MS Q&A platform.

    As per the error message, you need to add your email account explicitly to the database.

      .add database Test users ('aaduser=imikeoein@fabrikam.com') 'Test user (AAD)'  
    

    reference: https://learn.microsoft.com/en-ie/azure/data-explorer/kusto/management/access-control/principals-and-identity-providers

    If you have already added your account, could you please follow the below steps to grant the permissions to the service principal?

    Navigate to your Azure Data Explorer cluster

    In the Security+ networking section, select the permissions

    Click on Add and select AllDatabasesAdmin or AllDatabasesViewer

    Now search your Service principal and select

    247184-image.png

    ------------------------------

    If this answers your question, please consider accepting the answer by hitting the Accept answer button, as it helps the community.