Share via

Connection to a managed SQL instance using Microsoft Entra Integrated Authentication

Vishwanath K Bellubbi 0 Reputation points
2024-06-19T13:03:52.6933333+00:00

We need your assistance with connecting to a managed SQL instance using Microsoft Entra Integrated Authentication from VM. We're encountering the following error when attempting to connect.

This is required for migration of our solution to Cloud.

 

Error:

Test connection failed because of an error in initializing provider. Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated).

Error code 0xget_user_name_failed

Failed to get user name.

 

SQL Managed Instance Details:

Instance: tbss-dev-db-mi.public.8e8857a59101.database.windows.net,3342

VM: tbss - VM

Account used to connect: w2o2@erfitngdev.onmicrosoft.com

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 28,852 Reputation points Microsoft Employee
    2024-06-19T18:01:57.0666667+00:00

    @Vishwanath K Bellubbi Welcome to Microsoft Q&A thanks for posting your question.

    I suggest you to please follow the Blog here https://techcommunity.microsoft.com/t5/azure-sql-blog/make-your-azure-sql-managed-instance-passwordless/ba-p/2908166 and let me know if you are still facing the issue.

    Regards

    Geetha

    0 comments