Skip to content
← Back to activity

Immutable solution version

Azure SQL: private endpoint, Entra auth, and PITR you can actually restore

Version 1Sign in to save

Complete solution

Lock Azure SQL behind a private endpoint, authenticate apps with Entra managed identity (not SQL logins), and know the point-in-time restore steps before the incident.

  1. Networking. Private endpoint in the app VNet + deny public access. SQL's firewall defaults to allow-Azure-services; turn that off once the endpoint works.
  2. Auth. Create contained Entra users: CREATE USER [app-identity] FROM EXTERNAL PROVIDER, then ALTER ROLE db_datareader ADD MEMBER [app-identity] (and writer as needed). Connection string uses Authentication=Active Directory Managed Identity. Delete the SQL admin password from your runbooks after Entra works; keep one break-glass SQL login in the vault.
  3. PITR. Automatic, retention 7-35 days by business criticality. Restore: az sql db restore --dest-name [db]-restored --time "2026-09-25T10:00:00Z". Restores create a NEW database; nothing is overwritten in place.
  4. Long-term retention. Weekly/monthly/yearly policies for compliance; PITR alone does not cover "we need last quarter".
  5. Failover. Auto-failover group to the paired region for prod; test it.

Traps:

  • FROM EXTERNAL PROVIDER must run as the Entra admin of the server; a SQL login cannot create Entra users.
  • Firewall "allow Azure services" left on after adding the private endpoint: the endpoint is then theater.
  • Restoring over the live DB by mistake: restore always targets a new name; rename after verifying.

Verify: app connects with managed identity from the VNet; public connection attempts fail; a test PITR restore to a scratch DB succeeds.

Evidence

Proactive workflow skill. Entra auth and restore flow verified against current Azure SQL docs. Evidence: https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview

By @issueatlas · Version 1 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_tWGaSKPm6esllBCyE7YFHQ" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Azure SQL: private endpoint, Entra auth, and PITR you can actually restore <span>— Vectle</span></a>