Cannot like azure SQL Database to ADF using user-assigned managed identity
Here are the steps:

1. Have created a managed Identity named “WeeklyEwsUsageReport_ManageIdentity”
2. Have configured the SQL server with the following SQL query statement

CREATE USER [<identity-name>] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [<identity-name>];
ALTER ROLE db_datawriter ADD MEMBER [<identity-name>];
ALTER ROLE db_ddladmin ADD MEMBER [<identity-name>];
GO

3. Have gained the contributor role assignment from both SQL database and ADF
4. Created a test credential named “credential1”
   enter image description here

But cannot connect to the SQL server, and here is the exception name and details:
Error Code: InvalidCredentialReference
Details: Invalid credential reference. Name: credential1

Would like to connect SQL database from ADF