hasty idol
I set up an Azure SQL server and designated my Entra ID user (also known as an Active Directory user) as the administrator for the server. Then, I logged into my laptop's Microsoft account using that Entra ID and attempted to log in to the server using "Microsoft SQL Server Management Studio." I selected the authentication type as "Microsoft Entra Integrated," but encountered the following error:
TITLE: Connect to Server ------------------------------ Cannot connect to entraauth.database.windows.net. ------------------------------ ADDITIONAL INFORMATION: Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated). Error code 0xintegrated_windows_auth_not_supported_managed_user Integrated Windows Authentication is not supported for managed users. See https://aka.ms/msal-net-iwa for details. (Microsoft SQL Server, Error: 0) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-0-database-engine-error ------------------------------ BUTTONS: OK ------------------------------
It seems I may have overlooked some additional setup steps in this process. What should I do to log in using "Microsoft Entra Integrated" to my Azure SQL server? Essentially, I'm seeking an alternative to MSSQL Server's Windows authentication for Azure SQL Server, where I can log in without using SQL login credentials.
lilac quail