SQList supports the following Azure AD authentication methods to SQL Azure databases:
- Active Directory password authentication: use this method when you want to connect using a specific Azure AD user's credentials (username and password);
- Active Directory integrated authentication: use this method when you want to connect using the current user access rights. Note that this type of authentication requires that the SQList service is configured to run under that same user context.
In this article, we assume that the Azure AD users and groups and have already been created and assigned to the SQL Azure database.
If you need details about the correct way to configure them, please see this article (1):
(1) Note that this is a third-party article, we do not own now are responsible for its content.
Important: the instructions in the article above assign the user to the db_datawriter role, for SQList you need to assign it to the db_owner role.
We also assume that the SQL Azure server's firewall has been configure to let the IP address of the machine running SQList through. For more details see this support article:
Configure SQList to use Azure AD authentication
Configuring SQList o user Azure AD authentication is straight forward, you simply select the option "Connection string" in the Authentication Mode drop down for the database connection, copy and paste the connection string from the Azure portal, and replace the username and password placeholders. That is all.
Copy the connection string from the SQL Azure database's connections strings:
Configure the Database connection in SQList using the details from the connection string; note that the Server Name\Instance must contain the "tcp:" prefix and the port number: