Workato authentication to Azure SQL Database with Azure AD

Dwayne Lott 26 Reputation points

I have a client that would like to connect to my Azure SQL Database using Workato. I am unfamiliar with Workato.

I have setup an AD group called testdbreader. I added testdbreader as a user in the database and gave them db_datareader role, as follows.

create user [testdbreader] from external provider
alter role db_datareader add member [testdbreader]

I created an Azure AD user and assigned them to the testdbreader group.

Using SSMS, I successfully connect to the database. (FYI... I have also been able to connect using DBeaver SQL Client. So, I know it can be done through more than just SSMS.)

I added Workato's IP addresses to my firewall setup.

I have I am being told that the connection does not work via Workato.

Does anyone have experience with this type of authentication with Workato?


Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
14,915 questions
Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 28,116 Reputation points MVP

    Based on what I see on the authentication video shown on this Workato documentation page I can see that to connect to an Azure SQL database you have to provide the SQL login name and the database name in this format userlogin@DBase , however when you add an AD Azure user to Azure SQL you use the @ to specify the domain.

    CREATE USER [bob@Company portal .com] FROM EXTERNAL PROVIDER;

    So when you try to login as bob@Company portal .com where contoso is the Azure AD domain, the Workato authentication page will interpret that the contoso domain name is the database name and the authentication will fail.

    Based on above judgements I will say Workato only supports SQL authentication when using the "SQL Server connector".

0 additional answers

Sort by: Most helpful