Home
%3CLINGO-SUB%20id%3D%22lingo-sub-386135%22%20slang%3D%22en-US%22%3ECertificate-based%20authentication%20for%20Azure%20SQL%20DB%20using%20Azure%20Active%20Directory%20with%20recent%20Azure%20RM%20PowerShell%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386135%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Apr%2025%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20This%20is%20a%20new%20version%20of%20the%20previous%20blog%20on%20Token-based%20authentication%20(see%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlsecurity%2F2016%2F02%2F09%2Ftoken-based-authentication-support-for-azure-sql-db-using-azure-ad-auth%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlsecurity%2F2016%2F02%2F09%2Ftoken-based-authentication-support-for-azure-sql-db-using-azure-ad-auth%2F%20%3C%2FA%3E%20)%20updated%20to%20accommodate%20recent%20Azure%20RM%20PowerShell%20version.%20The%20certificate-based%20authentication%20allows%20to%20use%20a%20local%20certificate%20that%20can%20be%20registered%20with%20Azure%20AD%20to%20serve%20as%20an%20authentication%20mechanism%20to%20connect%20to%20Azure%20SQL%20DB%20without%20using%20user%2Fpassword%20or%20integrated%2Fwindows%20credentials.%20For%20more%20details%20see%20the%20attached%20Readme%20doc%20as%20well%20as%20the%20sample%20program%20attached%20in%20the%20zip%20file.%20The%20sample%20program%20requires%20Visual%20Studio%202015%20(or%20higher)%20with%20.NET%204.6%20(or%20higher)%20and%20ADALSQL.dll%20(see%20also%20the%20client%20setup%20requirement%20in%20the%20main%20MSDN%20document%20for%20Azure%20AD%20authentication%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fdocumentation%2Farticles%2Fsql-database-aad-authentication%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fdocumentation%2Farticles%2Fsql-database-aad-authentication%2F%20%3C%2FA%3E%20).%20For%20further%20questions%20on%20this%20topic%20please%20contact%20%3CBR%20%2F%3E%20MFAforSQLDB%40microsoft.com%20alias.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fmsdnshared.blob.core.windows.net%2Fmedia%2F2017%2F04%2FCertBased-AAD.SQLAuth1.zip%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20certbased-aad-sqlauth%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-386135%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Apr%2025%2C%202017%20This%20is%20a%20new%20version%20of%20the%20previous%20blog%20on%20Token-based%20authentication%20(see%20https%3A%2F%2Fblogs.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-386135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerSecurity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft
First published on MSDN on Apr 25, 2017
This is a new version of the previous blog on Token-based authentication (see https://blogs.msdn.microsoft.com/sqlsecurity/2016/02/09/token-based-authentication-support-for-a... ) updated to accommodate recent Azure RM PowerShell version. The certificate-based authentication allows to use a local certificate that can be registered with Azure AD to serve as an authentication mechanism to connect to Azure SQL DB without using user/password or integrated/windows credentials. For more details see the attached Readme doc as well as the sample program attached in the zip file. The sample program requires Visual Studio 2015 (or higher) with .NET 4.6 (or higher) and ADALSQL.dll (see also the client setup requirement in the main MSDN document for Azure AD authentication https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/ ). For further questions on this topic please contact
MFAforSQLDB@microsoft.com alias.

certbased-aad-sqlauth