This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 46%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELF%3C/text%3E%3C/svg%3E)
Hello,
Requirement: Add a contained database user for an Azure AD group to the database hosted by a dedicated or serverless sql pool on Azure Synapse Analytics workspace using powershell in an azure pipeline (automated)
Problem Statement: When attempting to do this, we first obtain a token, but invariably, regardless of the endpoint from which we obtain the token, we are getting "Login Failed for Token-Identified principal". We are using the service principal backing the Service Connection. This SPN is the Azure AD SQL Administrator on the Synapse Workspace.
Details:
Endpoints tested:
Is this connection method (i.e. using token) supported for Azure Synapse?
Is there an unpublished endpoint that I should be using?
Any assistance with this is greatly appreciated!
Hi @Lorrin Ferdinand ,
Welcome to the MS Q&A platform.
As per the discussion on the email, try to checkout the attachment and do let us know if any help needed.
And also, you may checkout the SO thread addressing similar issue.
Hi @Lorrin Ferdinand ,
Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Hello,
I haven't tried yet, but I did review the email. It appears there is promise. However, if you guys can find out what the correct endpoint is then I think this is where my problem lies at the moment.
Thanks,
Lorrin
Hi @Lorrin Ferdinand ,
Did you get a chance to try the suggestions mentioned in the email?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 32%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOM%3C/text%3E%3C/svg%3E)
Hey @Lorrin Ferdinand could you share the solution? We are facing the same problem.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 56.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Same problem here. Anyone solved the issue?