Forum Discussion

Microsoft

Mar 02, 2022

Connecting to dedicated and serverless pool via Invoke-SqlCmd using Token-Authentication

Hello All, I'm a data engineer wearing the hat of an DevOps engineer currently. I'm having a big struggle with trying to execute a T-SQL statement (CREATE USER <<>> FROM EXTERNAL PROVIDER) on an azur...

ssisjoost

Copper Contributor

Dec 21, 2023

Lorrin Any luck solving the issue? It seems that I have a similar problem with getting the token from/for the Synapase Serverless SQL pool: https://techcommunity.microsoft.com/t5/azure-synapse-analytics/get-token-for-synapse-serverless-sql-pool/m-p/4013912

Lorrin

Microsoft

Dec 21, 2023

ssisjoost

Unfortunately, we had to move onto other priorities. Maybe I'll give go-sqlcmd again - see link in the thread in my own environment and report back.

Regards,

Lorrin