Link external Azure SQL DB to Synapse with managed identity fails with SqlErrorNumber=18456,Class=14,State=1

Question

I am trying to link other Azure SQL DB's to my Synapse workspace.
I'd prefer using synapses managed identity, but it does not seem to work even after I added the identity to the SQL server IAM and have the firewall "Allow Azure services and resources to access this server" .
Also tried with service principal.
See screenshots.

Answer 1

Hi @Kovács, Ferenc ,
Thankyou for using Microsoft Q&A platform.
You need to set your System assigned Managed identity as 'Admin' in Azure Active directory.
Attaching Gif for your reference. Additionally, you can go through the following articles for better understanding:
System-assigned managed identity authentication

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators