Failed to authenticate the user in Active Directory for a db project with Visual Studio 2022 and SSDT

pmscorca 512 Reputation points
2024-01-23T11:26:07.67+00:00

Hi, I'm implementing a database project by using a Visual Studio 2022 (vers. 17.8.5) and SSDT environment. In particular, I need to build a db versus a Synapse dedicated SQL pool. When I try to edit the db connection in Properties --> Debug
User's image

I've this error:
User's image

The authentication occurs with the Microsoft Entra MFA. I haven't any issues trying the connection to the Synapse SQL pool by the SSMS tool. My account is a database user with the db_owner role. It is strange that the authentication failed inside Visual Studio and not in SQL Server Management Studio. No problems accessing via Azure Portal. Any suggests to me in order to solve a such issue? Thanks

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,145 questions
{count} votes