From the course: SQL Server: Security for Developers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Azure AD and SQL authentication

Azure AD and SQL authentication - SQL Server Tutorial

From the course: SQL Server: Security for Developers

Start my 1-month free trial

Azure AD and SQL authentication

“

- [Instructor] If you're working with SQL Server, you need to know a little bit about Active Directory. Also, if you're working with Azure SQL Database or Azure SQL Data Warehouse or Azure SQL Manage Instance or any of the other Microsoft platform as a service data offerings, you need to know a little bit about Azure Active Directory in terms of authentication. Both of these tools work together to provide a unified authentication experience for your users but they operate differently. So this is a screenshot from SQL Server Management Studio. You may have seen it when you've logged in and may have not understood what it refers to but we see a few different types of authentication here. So we see the traditional Windows authentication and SQL Server Authentication that we've always had in SQL Server. Windows authentication against on-premises Active Directory or possible Active Directory running in an Azure virtual machine. SQL Server authentication of course, authenticating against…

Contents