November 2017
Intermediate to advanced
276 pages
7h 6m
English
Content preview from Learning Microsoft Azure Storage
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Setting Azure AD authentication to Azure SQL Database
So far, we have been using SQL authentication to connect to Azure SQL Database, as we did in the previous chapter via SQL Server Management Studio.
Using Azure AD will provide centralized administration for database users' identities.
Doing so is very straightforward; you can follow the following steps to do so:
- Navigate to the Azure SQL Server and scroll down to Active Directory admin, as shown in the following screenshot:
Figure 5.10: Azure AD admins for the Azure SQL Server
- Click on Set admin and a new blade will pop up, as shown in the following screenshot:
Figure 5.11: Azure AD ...