{"id":3465,"date":"2016-09-27T16:51:07","date_gmt":"2016-09-27T16:51:07","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/premier_developer\/?p=3465"},"modified":"2019-02-14T20:27:54","modified_gmt":"2019-02-15T03:27:54","slug":"using-azure-ad-to-authenticate-public-clients-to-sql-azure","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/premier-developer\/using-azure-ad-to-authenticate-public-clients-to-sql-azure\/","title":{"rendered":"Using Azure AD to authenticate public clients to SQL Azure"},"content":{"rendered":"<p>In a recent post from his blog, Premier Developer Consultant\u00a0<a href=\"https:\/\/blogs.msdn.microsoft.com\/mrochon\/\"><span style=\"color: #337ab7\">Marius Rochon<\/span><\/a>\u00a0shows how to use Azure AD to authenticate public clients to SQL Azure.<\/p>\n<hr width=\"100%\" size=\"1\" align=\"center\" \/>\n<p>Azure AD enables access authorization to SQL Azure as an alternative to providing username\/password information in the connection string: <a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-aad-authentication\/\"><span style=\"color: #337ab7\">https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-aad-authentication\/.<\/span><\/a> It is somewhat analogous to using Windows Authentication when both the client and the database are on a Windows domain network. It is particularly useful on public (non-confidential) clients where storing secrets is inappropriate and the only alternative would be to have the user use special SQL-only credentials.<\/p>\n<p><a href=\"https:\/\/blogs.msdn.microsoft.com\/mrochon\/2016\/09\/22\/using-azure-ad-to-authenticate-public-clients-to-sql-azure\/\"><span style=\"color: #337ab7\">Continue reading on Marius Rochon\u2019s blog\u2026<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a recent post from his blog, Premier Developer Consultant\u00a0Marius Rochon\u00a0shows how to use Azure AD to authenticate public clients to SQL Azure. Azure AD enables access authorization to SQL Azure as an alternative to providing username\/password information in the connection string: https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-aad-authentication\/. It is somewhat analogous to using Windows Authentication when both the client [&hellip;]<\/p>\n","protected":false},"author":583,"featured_media":37840,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[149,69,11,3],"class_list":["post-3465","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-permierdev","tag-authentication","tag-azure-ad","tag-sql-azure","tag-team"],"acf":[],"blog_post_summary":"<p>In a recent post from his blog, Premier Developer Consultant\u00a0Marius Rochon\u00a0shows how to use Azure AD to authenticate public clients to SQL Azure. Azure AD enables access authorization to SQL Azure as an alternative to providing username\/password information in the connection string: https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/sql-database-aad-authentication\/. It is somewhat analogous to using Windows Authentication when both the client [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/3465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/users\/583"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/comments?post=3465"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/3465\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media\/37840"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media?parent=3465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/categories?post=3465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/tags?post=3465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}