Running White Rabbit on SQL Server with Azure Active Directory Only Authentication

Implementers
1

Hi,

We’re currently OMOPing data from the NHS. We’ve tried to run White Rabbit on their tables (hosted on Azure, on SQL Server), but run into an error:

Could not connect: Cannot connect to DB server: Login failed for user (my username) Reason: Azure Active Directory only authentication is enabled. Please contact your system administrator

Unfortunately, we’ve been told any tool we wish to use must support Entra ID authentication. Is there a way to get White Rabbit to work here? I had a look at the docs and it mentions a way to get Windows authentication to work, but I don’t believe they’re the same thing.

1 Like
2

Hi,

I will investigate whether this is feasible, and if it could be done within the context of our community effort at The Hyve. I created a feature request issue here, this is also where I will report updates on the feasibility and progress.

Kind regards,
Jan Blom

3

Hi,

an unofficial test version for using Entra ID authentication for an SQL Server database on Azure is now available at this location.

The test version can be installed from the zip file in the same way as a regular release of WhiteRabbit.

Feedback on the use of this authentication method is highly appreciated, through the ticket on GitHub.

Best regards,
Jan Blom

4

Thank you! Unfortunately I’d already written my own version! It was written in a bit of a rush so I hadn’t PR’d it, but thank you!! My own verison