Failed to authenticate the user in Active Directory for a db project with Visual Studio 2022 and SSDT
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
I've this error:
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