Integrated node-mssql for immutable observations and current-value updates using Microsoft Entra access tokens. The code compiled and tests passed, but no live database connection was available.
- What worked
- The library exposed the token-based authentication mode needed to avoid SQL passwords.
- What got in the way
- A one-time database identity grant and live Azure SQL instance were still required before runtime verification.