Synapse access using Azure Service Principal Authentication

[shoin]

WIN X64 server SAS 9.4 TS1M7

SAS ACCESS/ODBC

SYS DSN connection test is successful and uses Azure Service Principal Authentication

I am testing first in BASE editor (once connecting, then will test via EG and set up library in meta)

This is the error I am getting:

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver 18 for
       SQL Server][SQL Server]Error requesting access token, HTTP status 400,
       expected 200

I am searching on MS reference docs, there have been issues registered but with CLI not SAS (not much that I could find).  I am seeing anyone dealt with this before going to SAS TS.

Cheers & TIA

-S

[shoin · Accepted solution]

I had it resolved, this was more so to do with the ID and the token access value.  Once provided, worked like a charm.  

-S

[emmao]

Hi Shoin,

May I know how to set with the ID and the token access value in the caslib connection definition?

I can access data in Synapse general table whether sparkpool or the dedicated/deafult one.

But there's authorized error came when I try to open the table in dedicated external table in Synapse through CAS or libname.

ERROR: CLI open cursor error: [SAS][ODBC SQL Server Wire Protocol driver][SQL Server Azure Data Warehouse]Not able to validate 
       external location because The remote server returned an error: (401) Unauthorized.

[Mayankp]

@shoin we have similar requirements to connect to Azure Synapse SQL (Serverless), Are you able to share more details on driver and odbc.ini parameters?

Thanks.