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.