SQL Azure troubleshooting

When attempting to use a Azure SQL data source, you receive the error message below;

"UNABLE TO LOAD ADALSQL.DLL (ATHENTICATION=ACTIVEDIRECTORYPASSWORD). ERROR CODE: 0X2. FOR MORE INFORMATION, SEE HTTP://GO.MICROSOFT.COM/FWLINK/?LINKID=513072" !!KB2007

Solution

To resolve this issue, please have a look at Azure SQL.

When creating a user with Entra ID account authentication, you see the error below;

"PRINCIPAL '' COULD NOT BE CREATED. ONLY CONNECTIONS ESTABLISHED WITH ACTIVE DIRECTORY ACCOUNTS CAN CREATE OTHER ACTIVE DIRECTORY USERS." !!KB2008

Solution

You must first define your SQL Server Entra ID Admin via the Azure Portal, then login into Remote Desktop Manager using that Entra ID account, from there you will be able to create new Entra ID accounts (admin and non-admin). Those new admins will also be able to do the same.

For more information, please have a look at Configure the Entra ID administrator.

Devolutions Forum logo Give us Feedback