topic Re: Synapse access using Azure Service Principal Authentication in Administration and Deployment

Synapse access using Azure Service Principal Authentication

shoin — Thu, 07 Jul 2022 16:52:08 GMT

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

Re: Synapse access using Azure Service Principal Authentication

shoin — Wed, 20 Jul 2022 22:03:50 GMT

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

Re: Synapse access using Azure Service Principal Authentication

emmao — Thu, 01 Sep 2022 08:41:52 GMT

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.

Re: Synapse access using Azure Service Principal Authentication

Mayankp — Thu, 25 Jan 2024 04:27:13 GMT

@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.