Hello,
Currently, it seems that MSSQL database connections only support SQL authentication, which has worked fine for me so far.
For a new integration, however, I need to connect to an MSSQL database using a Microsoft Entra Service Principal. I have already tried using the Client ID and secret of the service principal as the username and password, but that does not work.
The authentication method needs to be explicitly specified. Could support for this be added in the future? (more info about the authentication method I need can be found here: Connect to Server (Login Page) - Database Engine | Microsoft Learn )
Thanks in advance!
Kind regards,
Luuk
Hi @l.jakobs,
Thank you for your detailed explanation and for sharing your use case.
We understand the importance of supporting modern and secure authentication mechanisms like this, especially for integrations with Azure-based environments.
We have therefore logged this as a feature request with our development team to evaluate adding support for Microsoft Entra Service Principal authentication in future updates.
At the moment, there is no direct workaround within Alumio to use this authentication method. If possible, we would recommend checking whether SQL authentication can be temporarily enabled on the database side for this integration.
Please let us know if you have any additional questions in the meantime.