Lesson Learned #70: Is ASP Classic able to connect to Azure SQL Database using Azure Active Directory?

Published 03-13-2019 07:39 PM 1,452 Views
First published on MSDN on Jan 30, 2019
Hello,

Today, I worked on a service request that our customer has an application developed in ASP Classic and they want to use Azure Active Directory using the validation of User/Password, it is not possible.

Initially, Azure Active Directory is possible to use .NET 4.6 based on this URL .

I suggested to use the ODBC v.13 that contains all these changes in order to connect to the database using Azure Active Directory and it works. Also, using other tools like Excel, Word, etc.

Simply, change the connectionstring Driver={ODBC Driver 13 for SQL Server};server=xxxxx.database.windows.net;Authentication=ActiveDirectoryPassword;Database=xxxxx;User ID=xxxxxx@xxxxx.xxx;Password=xxxx;Current Language=Spanish

Enjoy!
%3CLINGO-SUB%20id%3D%22lingo-sub-369185%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%2370%3A%20Is%20ASP%20Classic%20able%20to%20connect%20to%20Azure%20SQL%20Database%20using%20Azure%20Active%20Directory%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369185%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%20Jan%2030%2C%202019%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20Hello%2C%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Today%2C%20I%20worked%20on%20a%20service%20request%20that%20our%20customer%20has%20an%20application%20developed%20in%20ASP%20Classic%20and%20they%20want%20to%20use%20Azure%20Active%20Directory%20using%20the%20validation%20of%20User%2FPassword%2C%20it%20is%20not%20possible.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Initially%2C%26nbsp%3BAzure%20Active%20Directory%20is%20possible%20to%20use%20.NET%204.6%20based%20on%20this%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-aad-authentication-configure%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20URL%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20I%20suggested%20to%20use%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D50420%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20ODBC%20v.13%20%3C%2FA%3E%20that%20contains%20all%20these%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Fodbc%2Fwindows%2Fmicrosoft-odbc-driver-for-sql-server-on-windows%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20changes%20%3C%2FA%3E%20in%20order%20to%20connect%20to%20the%20database%20using%20Azure%20Active%20Directory%20and%20it%20works.%20Also%2C%20using%20other%20tools%20like%20Excel%2C%20Word%2C%20etc.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Simply%2C%20change%20the%20connectionstring%20Driver%3D%7BODBC%20Driver%2013%20for%20SQL%20Server%7D%3Bserver%3Dxxxxx.database.windows.net%3BAuthentication%3DActiveDirectoryPassword%3BDatabase%3Dxxxxx%3BUser%20ID%3Dxxxxxx%40xxxxx.xxx%3BPassword%3Dxxxx%3BCurrent%20Language%3DSpanish%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Enjoy!%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-369185%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jan%2030%2C%202019%20Hello%2CToday%2C%20I%20worked%20on%20a%20service%20request%20that%20our%20customer%20has%20an%20application%20developed%20in%20ASP%20Classic%20and%20they%20want%20to%20use%20Azure%20Active%20Directory%20using%20the%20validation%20of%20User%2FPassword%2C%20it%20is%20not%20possible.%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Mar 13 2019 07:39 PM
Updated by: