Error connecting to Azure SQL DB using Active Directory Authentication

rpellicaan — Tue, 28 Sep 2021 10:24:21 GMT

Hi,

I am having trouble connecting to a Azure SQL Database from SAS using Azure Active Directory Authentication. This is our first attempt to connect to a Azure SQL DB.

I can successfully connect to the database using sql-authentication (odbc.ini AuthenticationMethod=1), but when I switch to AuthenticationMethod=13, I get the following error:

ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Wire Protocol driver]HY000Failed to connect() to host or proxy. : [SAS][ODBC SQL Server Wire Protocol driver]Failed to authenticate the user 'xxxx@xxxx.onmicrosoft.com' in
Active Directory (Authentication Method is '13 - Active Directory Password').

NOTE: It takes 10 minutes and 1 second for this error to occur, so it seems like there is some kind of time-out occuring.

I found https://support.sas.com/kb/67/463.html , but that is not the error I get (I have ValidateServerCertificate=0 set in de odbc.ini).
This article has the same error message:

https://knowledgebase.progress.com/articles/Article/The-connection-to-SQLServer-Azure-using-Active-Directory-fails-when-connecting-with-the-ODBC-driver.
but I don't how these drivers version related to the ones that are supplied by SAS.

Has anybody got a clue?

Is it possible to use integrated authentication (kerberos) from SAS to Azure SQL Database, or is only username/password authentication possible?

Re: Error connecting to Azure SQL DB using Active Directory Authentication

rpellicaan — Tue, 28 Sep 2021 10:26:31 GMT

Note: we are running SAS 9.4 M6 on AIX, using SAS/ACCESS Interface to Microsoft SQL Server

Re: Error connecting to Azure SQL DB using Active Directory Authentication

SASKiwi — Thu, 30 Sep 2021 01:56:00 GMT

This looks like a tricky database connection configuration problem. Getting help from SAS Tech Support is probably your best option.

topic Error connecting to Azure SQL DB using Active Directory Authentication in Administration and Deployment

Error connecting to Azure SQL DB using Active Directory Authentication

Re: Error connecting to Azure SQL DB using Active Directory Authentication

Re: Error connecting to Azure SQL DB using Active Directory Authentication