Azure SQL DB - MFA Authentication - AnalyticsCreator Forum

Azure SQL DB - MFA Authentication

StephenEdwards

I am currently trialing Analytics Creator and trying to connect to an Azure SQL DB but get "Windows Logins Cannot Be Used" - Our organisation uses MFA Authentication, any suggestions?

DimitriSorokin

At the moment we support only standard SQL security for repository databases located on SQL Azure.
To connect you should select Standart SQL Security option and enter valid user name and password.
I would suggest to develop locally using SQL Server Express and then deploy the DWH on Azure.

StephenEdwards

DimitriSorokin Many thanks for the response. I have managed to overcome this by creating an ODBC connection which manages the MFA requirements.

DimitriSorokin

Hello Stephen,
i think I misunderstood you - I though you will create AC repository on Azure SQL Server.
To connect to the source located on Azure using Azure Active Directory security you can use the following connection string for SQL Server OLEDB driver: Source

Provider=MSOLEDBSQL;Data Source=[server];Initial Catalog=[database];Authentication=ActiveDirectoryServicePrincipal;User ID=[Application (client) ID];Password=[Application (client) secret];Use Encryption for Data=true

[server] is sometning like yourservername.database.windows.net
[Application (client) ID] is your AD user, like myuser@mydomain.com
[Application (client) secret] is your AD password