Aug. 11, 2023, 3:54 p.m. | Muhammad Shakir

System Weakness - Medium systemweakness.com

Configure secret-less SQL Authentication for Azure App Service and Azure DevOps pipeline via Terraform

While multiple approaches exist for connecting to the SQL server, this discussion will exclusively centre around two specific authentication modes that enable us to connect the SQL server from either Azure App Service or Azure DevOps pipeline.

  • SQL authentication with Active Directory using Managed Identity (MSI)
  • SQL authentication with Active Directory using a Service Principal and Client Secret

SQL authentication with Managed Identity

Managed identities for …

app application app service authentication azure connect devops enable pipeline secret security server service sql sql server terraform

Red Team Operator

@ JPMorgan Chase & Co. | LONDON, United Kingdom

SOC Analyst

@ Resillion | Bengaluru, India

Director of Cyber Security

@ Revinate | San Francisco Bay Area

Jr. Security Incident Response Analyst

@ Kaseya | Miami, Florida, United States

Infrastructure Vulnerability Consultant - (Cloud Security , CSPM)

@ Blue Yonder | Hyderabad

Product Security Lead

@ Lely | Maassluis, Netherlands