SQL connection with Azure Active Directory

Help Studio
1

I am trying to connect to SQL Server with authentication type “Connection to SQL server with Azure Active Directory Univesal with MFA”. I see only two option in the connection activity under database activities where one is for windows authentication and the other is SQL server authentication.

How do I connect with this authentication type.

2

I also have similar situation. Were you able to get hold of solution for this. Also the authentication used for this is ActiveDirectoryInteractive which you can set by going to advanced in connection wizard but then it is leading me to some other errors. So no definite solution here

3

I know this is an old post… but maybe someone is looking for an answer.

You just have to make sure you have de ADALSQL.MSI pacakge installed from Microsoft website, after which you can go to the SQL Wizard and make sure you choose what you need from there:

image
image1032×707 43.5 KB

4

Hi @pdevakumar ,

I’m also facing the same problem - did you manage to resolve it in the end?