{"id":42758,"date":"2022-07-28T08:00:00","date_gmt":"2022-07-28T15:00:00","guid":{"rendered":""},"modified":"2024-04-19T10:32:50","modified_gmt":"2024-04-19T17:32:50","slug":"azure-active-directory-authentication-for-sql-server-2022","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/","title":{"rendered":"Azure Active Directory authentication for SQL Server 2022"},"content":{"rendered":"\n<p><em>Part of the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/tag\/sql-server-2022-blogging-series\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server 2022 blog series<\/a>.<\/em><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/azure-ad-authentication-sql-server-overview?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Azure Active Directory (Azure AD) authentication<\/a> is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"azure-ad-authentication-methods\">Azure AD Authentication methods&nbsp;<\/h2>\n\n\n\n<p>The new functionality extends existing authentication modes, such as\u202f<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/choose-an-authentication-mode\" target=\"_blank\" rel=\"noreferrer noopener\">SQL authentication and Windows authentication,<\/a> allowing users to connect to SQL Server 2022 using the following Azure AD authentication methods:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&nbsp;Azure Active Directory Password&nbsp;<\/li>\n\n\n\n<li>&nbsp;Azure Active Directory Integrated&nbsp;<\/li>\n\n\n\n<li>&nbsp;Azure Active Directory Universal with Multi-Factor Authentication&nbsp;<\/li>\n\n\n\n<li>&nbsp;Azure Active Directory access token&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>For more details, see <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/azure-ad-authentication-sql-server-overview?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Azure Active Directory (Azure AD) authentication for SQL Server overview.<\/a><\/p>\n\n\n\n<p>The new authentication mode using Azure AD is based on the central authentication repository provided for Azure cloud.&nbsp;This functionality is already supported for Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"enable-azure-ad-authentication-in-sql-server-2022\">Enable Azure AD authentication in SQL Server 2022<\/h2>\n\n\n\n<p>The diagram below presents two stages required for a SQL Server 2022 instance to support Azure AD authentication:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Azure AD setup&nbsp;&nbsp;<\/li>\n\n\n\n<li>Azure AD user authentication<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp\" alt=\"Diagram of the use of Azure Arc to enable Azure AD authentication for SQL Server 2022.\" class=\"wp-image-43424 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-300x160.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-768x410.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-800x427.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-400x214.webp 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title.webp 1455w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp\"><\/figure>\n\n\n\n<p>Steps for Azure AD setup based on the diagram above:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Using Azure Arc in the Azure portal, register a host server (an on-premises Windows or Linux server) with a SQL Server 2022 instance installed on this server. This registration creates an Azure Arc agent on the host server, and you will have a new <strong>SQL Server \u2013 Azure Arc<\/strong> resource.<\/li>\n\n\n\n<li>In your <strong>SQL Server \u2013 Azure Arc<\/strong> resource, go to the <strong>Azure Active Directory<\/strong> setting to set up an Azure AD administrator for the SQL Server instance.<\/li>\n\n\n\n<li>This setup triggers the <strong>Azure AD administrator<\/strong> data transfer to Azure Arc agent.<\/li>\n\n\n\n<li>The Azure Arc agent transfers this information to the SQL Server instance.<\/li>\n<\/ol>\n\n\n\n<p>For more details on the Azure AD setup, see set up Azure Active Directory authentication for SQL Server.<\/p>\n\n\n\n<p>Steps for Azure AD user authentication based on the diagram above:<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\">\n<li>Using an application\u2014for example, SQL Server Management Studio (SSMS) version 18.0 or higher\u2014to connect to the SQL Server instance with the Azure AD admin credentials set up for the SQL Server instance (see the snapshots below).<\/li>\n<\/ol>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/image-62db068255437.webp\" alt=\"Example SSMS connection page using the authentication method, Azure Active Directory - Universal with MFA.\" class=\"wp-image-42761 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/image-62db068255437.webp\"><\/figure>\n\n\n\n<p>In the <strong>Options&gt;&gt;<\/strong> tab, check the boxes for <strong>Encrypt Connection<\/strong> and <strong>Trust server certificate<\/strong>.<\/p>\n\n\n\n<p>If you are using the Azure AD admin, the database connection to <strong>&lt;default&gt;<\/strong> (master database) or any other user database is allowed.&nbsp;For other Azure AD users, a connection to a specific user database may be required as they will need permission to connect to that database.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\">\n<li>After being authenticated as an Azure AD admin, database operations can be executed.<\/li>\n<\/ol>\n\n\n\n<p>Once the Azure AD admin is connected to the SQL Server instance, the account can create other Azure AD logins and users, and grant them necessary database permissions. For more details see, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/azure-ad-authentication-sql-server-setup-tutorial?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Set up Azure Active Directory authentication for SQL Server<\/a>.<\/p>\n\n\n\n<p>SQL Server 2022 also supports linked servers\u202fthat can be configured using Azure AD with two authentication mechanisms, by providing credentials for <strong>Password<\/strong> or <strong>Access token<\/strong>. For more information see Linked server for SQL Server with Azure Active Director authentication.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"benefits-of-using-azure-ad-authentication\">Benefits of using Azure AD authentication<\/h2>\n\n\n\n<p>Enabling Azure AD authentication opens access to the Azure cloud identity system. Azure AD is used by many cloud services and unifies all local authentication mechanisms used by Microsoft products providing one central identity repository and authentication management system available to different platforms, including Azure SQL and SQL Server on-premises. The variety of available authentication methods including single sign-on (SSO) and multifactor authentication (MFA), provides strong security support in the authentication area for different services used internally by Microsoft and by external customers. Azure AD authentication is the recommended authentication method for Azure SQL and SQL Server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"availability\">Availability&nbsp;<\/h2>\n\n\n\n<p>Not all Azure AD authentication functionality available for Azure SQL is supported in the current version of Azure AD authentication for SQL Server 2022. That includes <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/authentication-azure-ad-only-authentication?view=azuresql&amp;tabs=azure-cli\" target=\"_blank\" rel=\"noreferrer noopener\">Azure AD-only authentication,<\/a> as well as <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/authentication-azure-ad-user-assigned-managed-identity?view=azuresql\" target=\"_blank\" rel=\"noreferrer noopener\">User and System Assigned Managed Identity (UMI and SMI),<\/a> which are not supported for the SQL Server 2022 release. In addition, Azure AD authentication is not part of the main SQL Server 2022 setup and must be enabled later as a separate step after SQL Server is installed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"next-steps\">Next steps<\/h2>\n\n\n\n<p>Download the &nbsp;<a href=\"https:\/\/info.microsoft.com\/ww-landing-sql-server-2022.html\">SQL Server 2022 Preview<\/a> trial\u202fversion if you haven\u2019t already done so, and set up Azure AD authentication for your SQL Server instance. Share your experiences with us and let us know your comments.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"azure-active-directory-resources\">Azure Active Directory resources<\/h2>\n\n\n\n<p>For more information and to get started, check out the following links:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/azure-arc\/connect\" target=\"_blank\" rel=\"noreferrer noopener\">Connect SQL Server to Azure Arc<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/azure-ad-authentication-sql-server-overview?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Azure Active Directory (Azure AD) authentication for SQL Server overview<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/azure-ad-authentication-sql-server-setup-tutorial?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Set up Azure Active Directory authentication for SQL Server<\/a>. <\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/authentication-access\/azure-ad-authentication-sql-server-linked-server?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Linked server for SQL Server with Azure Active Director authentication<\/a>.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"learn-more\">Learn more<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Intelligent Data Platform<\/strong>: read how you can <a href=\"https:\/\/aka.ms\/BuildMay22\/DataBlog\" target=\"_blank\" rel=\"noreferrer noopener\">innovate faster and achieve greater agility<\/a> with the <a href=\"https:\/\/aka.ms\/BuildMay22\/DataBlog\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Intelligent Data Platform<\/a> and turn your data into decisions.<\/li>\n\n\n\n<li><strong>Download<\/strong>: get started today by <a href=\"http:\/\/aka.ms\/getsqlserver2022\" target=\"_blank\" rel=\"noreferrer noopener\">downloading the preview<\/a> or <a href=\"https:\/\/ms.portal.azure.com\/#create\/Microsoft.AzureSQL\" target=\"_blank\" rel=\"noreferrer noopener\">deploying in Azure<\/a>! To install SQL Server 2022 in preview on Linux, see <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-setup-2022?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">installation guidance<\/a>.<\/li>\n\n\n\n<li><strong>Documentation and Training:<\/strong> learn more about the features of SQL Server 2022 by reading the <a href=\"https:\/\/aka.ms\/sqlserver2022docs\" target=\"_blank\" rel=\"noreferrer noopener\">documentation<\/a> and watching the <a href=\"http:\/\/aka.ms\/dataexposed-sqlserver2022\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server 2022 Data Exposed video series<\/a>.<\/li>\n\n\n\n<li><strong>Feedback<\/strong>: let us know if you have any thoughts or feedback through our <a href=\"https:\/\/aka.ms\/sqlfeedback\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server feedback portal<\/a>. We look forward to seeing how SQL Server 2022 will transform your business in the future.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.<\/p>\n","protected":false},"author":6189,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[5278],"product":[5227,3645],"content-type":[2424],"topic":[],"coauthors":[5102],"class_list":["post-42758","post","type-post","status-publish","format-standard","hentry","tag-sql-server-2022-blogging-series","product-sql","product-sql-server-2022","content-type-best-practices","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure Active Directory authentication for SQL Server 2022 - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Active Directory authentication for SQL Server 2022 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-28T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-19T17:32:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp\" \/>\n<meta name=\"author\" content=\"Mirek Sztajno\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mirek Sztajno\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/mirek-sztajno\/\",\"@type\":\"Person\",\"@name\":\"Mirek Sztajno\"}],\"headline\":\"Azure Active Directory authentication for SQL Server 2022\",\"datePublished\":\"2022-07-28T15:00:00+00:00\",\"dateModified\":\"2024-04-19T17:32:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/\"},\"wordCount\":890,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp\",\"keywords\":[\"SQL Server 2022 Blogging Series\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/\",\"name\":\"Azure Active Directory authentication for SQL Server 2022 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp\",\"datePublished\":\"2022-07-28T15:00:00+00:00\",\"dateModified\":\"2024-04-19T17:32:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title.webp\",\"width\":1455,\"height\":777,\"caption\":\"diagram\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure Active Directory authentication for SQL Server 2022\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure Active Directory authentication for SQL Server 2022 - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/","og_locale":"en_US","og_type":"article","og_title":"Azure Active Directory authentication for SQL Server 2022 - Microsoft SQL Server Blog","og_description":"Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2022-07-28T15:00:00+00:00","article_modified_time":"2024-04-19T17:32:50+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp","type":"","width":"","height":""}],"author":"Mirek Sztajno","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Mirek Sztajno","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/mirek-sztajno\/","@type":"Person","@name":"Mirek Sztajno"}],"headline":"Azure Active Directory authentication for SQL Server 2022","datePublished":"2022-07-28T15:00:00+00:00","dateModified":"2024-04-19T17:32:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/"},"wordCount":890,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp","keywords":["SQL Server 2022 Blogging Series"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/","name":"Azure Active Directory authentication for SQL Server 2022 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title-1024x547.webp","datePublished":"2022-07-28T15:00:00+00:00","dateModified":"2024-04-19T17:32:50+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/07\/176930_Figure-1_no-title.webp","width":1455,"height":777,"caption":"diagram"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/28\/azure-active-directory-authentication-for-sql-server-2022\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Azure Active Directory authentication for SQL Server 2022"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/42758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/6189"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=42758"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/42758\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=42758"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=42758"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=42758"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=42758"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=42758"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=42758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}