Tag: WebAPI

Authenticate to a WebAPI using AAD with SQL Server

Prerequisites Have an Azure subscription. Have an Azure SQL Server in that subscription. Have an Azure SQL database named “Logbook” hosted by that Azure SQL Server. Install the Az PowerShell Module. Install the latest version of SQL Server Management Studio (SSMS) (currently v18.5). Background Information https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication https://docs.microsoft.com/en-us/azure/app-service/configure-authentication-provider-microsoft https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-mvc-app/start-mvc?view=aspnetcore-3.1&tabs=visual-studio This uses SQL Server Express LocalDB, not full …

Continue reading