Plugin Title | Azure Active Directory Admin Enabled |
Cloud | AZURE |
Category | SQL Server |
Description | Ensures that Active Directory admin is enabled on all SQL servers. |
More Info | Enabling Active Directory admin allows users to manage account admins in a central location, allowing key rotation and permission management to be managed in one location for all servers and databases. |
AZURE Link | https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure |
Recommended Action | Ensure Azure Active Directory admin is enabled on all SQL servers. |
- Log in to the Microsoft Azure Management Console.
- Select the "Search resources, services, and docs" option at the top and search for "SQL servers".
- On the "SQL server" page, select the SQL server that needs to be examined.
- On the selected "SQL server" page, scroll down the left navigation panel and select "Azure Active Directory" under "Settings".
- On the "Azure Active Directory" page, if "Admin name" under "Azure Active Directory admin" states "No Active Directory admin" then Azure Active Directory admin is not enabled on selected SQL server.
- To enable Azure Active Directory admin click on "Set admin" at the top.
- On the Azure Active Directory pop up, search for the desired admin name and select the user from the results and click "Select" button at the bottom of the page.
- Click the "Save" button at the top to make the changes.
- Repeat steps 3 - 8 to ensure Azure Active Directory admin is enabled on all SQL servers.