Azure Synapse Analytics | Login failed for user '<token-identified principal>'

user_6216719 0
Viewed 6290

I have created a dedicated SQL pool in Azure Synapse Analytics. When I am trying to create a table in my dedicated SQL pool then it is showing below error.

Login failed for user < token-identified principal>

Things I tried-

  • Reset user credentials
  • Login from multiple machines.
  • Pause and resume dedicated SQL pool

User I am using has workspace admin role. Attaching screenshot below.

enter image description here

azure-synapse entity-framework-core azure
2 Answers

You have to give SQL Active directory admin permission to access from your email-id

yourworkspace-->settings-->SQL Active Directory admin(left side list menu)-->setadmin  then ***save***

Screen shot

If you want to give access to many users you have to create security group and add user in it and assign to this SQL Active Directory admin

user_106911910

Currently, the Access control within Synapse Studio does not apply to dedicated SQL pools. Workspace admin can create a user manually through T-SQL or they can add you through SQL Active Directory Admin option when they navigate to workspace resource in Azure Portal.

user_81884330
Related