SQL server with Azure AD-only authentication.

Azure Public Test Date Azure Public Test Result

Azure US Gov Last Test Date Azure US Gov Last Test Result

Best Practice Check Cred Scan Check

Deploy To Azure Deploy To Azure US Gov Visualize

This template allows you to create an Azure SQL logical server with Azure AD-only authentication enabled.

Tags: Azure, SQL logical server, Azure AD-only authentication, Microsoft.Sql/servers

Deployment steps

  • Click the Deploy to Azure button and fill in the parameters to deploy a sample Azure SQL logical server with Azure AD-only authentication enabled.
  • An Azure AD admin will need to be set in order to enable Azure AD-only authentication.
  • Choose an Azure AD admin for the deployment. You will find the user Object ID by going to the Azure portal and navigating to your Azure Active Directory resource. Under Manage, select Users. Search for the user you want to set as the Azure AD admin for your Azure SQL server. Select the user, and under their Profile page, you will see the Object ID.
  • The Tenant ID can be found in the Overview page of your Azure Active Directory resource.