Forum Discussion
Lorrin
Microsoft
MicrosoftConnecting 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...
Hi, have you been able to get any progress on this ? I am facing the same problem. 🙂 I'm getting an access token from within my pipeline via `
az account get-access-token --resource="https://database.windows.net"` and try to use that token for connecting to the Synapse Serverless SQL Database using Invoke-SqlCmd, but I'm facing the same error as you're facing.
The service-principal that is behind the service-connection does have access-rights on Synapse. (It's a synapse administrator)
- Не удаётся открыть эти ссылки. Одну открыл , но еррор. 🙂
LorrinHello,
I don't have all the rights needed but one of the suggestions was to use a new version of sqlcmd that does have the right capabilities. I'm waiting for my client to install it on the agent pools. Here is the repo on git: https://github.com/microsoft/go-sqlcmd
You might try this in your environment.
Good luck!
Lorrin
