#15596·activepieces

[Feature]:[Pieces] Microsoft SQL Server piece — Entra ID (service principal) auth for Azure SQL

Author: majewskibartoszCreated Sep 17, 2026Updated Sep 17, 2026
Labels🌟 feature🧩 area/third-party-pieces🛟 support

Problem

The microsoft-sql-server piece supports SQL Server authentication only. auth.ts exposes host/port/database/user/password and a connection string, and buildConfig in src/lib/common/index.ts explicitly throws on any Authentication=Active Directory* connection string. A tenant configured for Entra SQL auth with an app registration has no way to connect.

Ref: Pylon 6019

Proposed

Add Entra service principal auth to the connection: Tenant ID, Client ID, Client Secret props, mapped to authentication: { type: 'azure-active-directory-service-principal-secret', options: { clientId, clientSecret, tenantId } }. Lift the Active Directory rejection when those fields are set.

No new dependency: mssql 12.7.0 pulls tedious 19.2.2, which already bundles @azure/identity and supports this auth type. Existing SQL-auth connections unchanged.

Source: activepieces/activepieces