Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Learning Microsoft Azure Storage

You're reading from  Learning Microsoft Azure Storage

Product type Book
Published in Nov 2017
Publisher Packt
ISBN-13 9781785884917
Pages 276 pages
Edition 1st Edition
Languages
Author (1):
Mohamed Waly Mohamed Waly

Table of Contents (9) Chapters

Preface 1. Understanding Azure Storage 101 2. Delving into Azure Storage 3. Azure Storage for VMs 4. Implementing Azure SQL Databases 5. Beyond Azure SQL Database Management 6. Azure Backup 7. Azure Site Recovery 8. Extending Your Azure Storage Management

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:

  1. 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
  1. Click on Set admin and a new blade will pop up, as shown in the following screenshot:
Figure 5.11: Azure AD users and groups
  1. Select the desired user or group to be added as an AD admin on the SQL Server, then save your changes to be applied to the SQL Server, as shown in the following screenshot:
Figure 5.12: Saving changes to the SQL Server...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime}