Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

SSO AAD with SQL Server

Hello everyone,   I'm trying to use use SSO with Azure AD with direct query to ensure the right level of security But once I open a report in direct query, it returns the following error message ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Based on your own description, I think first you need to make sure that SQL Server is configured to support Azure AD authentication. SQL Server must be set up to accept Azure AD authentication for SSO to work properly. You can refer to this document below: Configure Microsoft Entra authentication - Azure SQL Database & SQL Managed Instance & Azure Synapse Analytics | Microsoft Learn


I also noticed that the error message mentions a login name from an untrusted domain. Make sure that the domain of the user account is trusted by SQL Server. Similarly, confirm that the user attempting to access the report via DirectQuery is properly mapped in SQL Server with the appropriate permissions.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for your reply
    I'm using SQL Server (on-prem) but I will have a look on the ressource you shared
    I will keep you inform if I was able to solve this issue

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi  Anonymous,

      Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

       

       

       

      Best Regards

      Yilong Zhou

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.