SQL Azure troubleshooting

Issue 1: Unable to connect to the database

When attempting to use a Azure SQL workspace, you receive this error message:

Unable to connect to the database!

Unable to load adalsql.dll (Authentication=ActiveDirectoryPassword). Error code: 0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072

Solution 1

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

Issue 2: Unable to save the user in the database

When creating a user with Entra ID account authentication, you receive this error message:

Unable to save the user in the database!

Principal '...' could not be created. Only connections established with Active Directory accounts can create other Active Directory users.

Solution 2

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, have a look at Configure the Entra ID administrator.