Share via

Unable to enable Microsoft Entra authentication for SQL Server 2022 in Azure Arc page in azure portal

Chew Kok Hoor 20 Reputation points
2024-02-20T12:09:59.7666667+00:00

I tried enabling Entra ID in Microsoft Entra ID and Purview for my on premise SQL Server 2022 server registered successfully in Azure Arc. I have also added key vault access policy to the server name, and enabled network access from the server ip.

I receive following error:

Exception occurred while downloading AAD certificate. Unable to get a valid certificate from AKV. AKV does not contain a valid certificate that can be used for AAD authentication.. Exception occurred while installing AAD certificate. https://###.vault.azure.net/secrets/###-MSSQLSERVER######### Some or all identity references could not be translated.Exception occurred while installing AAD certificate. https://###.vault.azure.net/secrets/###-MSSQLSERVER##########

I have tried various settings including using service managed or customer managed keys and application but is the same error.

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
337 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,869 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,802 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chew Kok Hoor 20 Reputation points
    2024-02-20T16:03:06.02+00:00

    [UPDATE: Entra ID still not working even after updating SQL Server 2022 Web Edition to Update 11 and updated SQL Server Management Console to leatest. Somehow reappears again.]

    Problem is resolved by updating to the latest Cumulative Update 11. However, I still face issue with error:

    TITLE: Connect to Server

    Cannot connect to #######.

    ADDITIONAL INFORMATION: Login failed for user ''. (Microsoft SQL Server, Error: 18456) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error Upon checking in Azure Arc, the Entra admin became None again. Microsoft Entra admin Microsoft Entra authentication allows you to centrally manage identity and access to your Azure Arc enabled SQL Server. Admin login: None

    0 comments