Would like to be able to connect to an Azure SQL database from On Prem Cyberark using Azure Active Directory - Universal with MFA authentication, but the SSMS command does not support it yet. Has anyone come up with a workaround for this?

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Would like to be able to connect to an Azure SQL database from On Prem Cyberark using Azure Active Directory - Universal with MFA authentication, but the SSMS command does not support it yet. Has anyone come up with a workaround for this?

L4 Transporter

Would like to be able to connect to an Azure SQL database from On Prem Cyberark using Azure Active Directory - Universal with MFA authentication, but the SSMS command does not support it yet. Has anyone come up with a workaround for this?

 

Field_Content_versions_oct20__068Vy00000ucmYEIAY.png

3 REPLIES 3

L7 Applicator

Hi @Michael Driscoll​ 

 

I don’t think this workflow is supported OOTB yet.

 

It will need a custom connector.

 

The issue is the interactive window for MFA.

 

A custom connector should be possible that can handle interactive window to fetch token before launching SSMS or to interact with the SSMS login window programmatically.

 

Then custom connector then can be used this by using token to connect to Azure SQL, by launching SSMS with parameters.

 

Can you use CLI through PowerShell script instead of SSMS? It will be easier to pass token in CLI

 

The best approach is to contact CyberArk and see if possible to build a custom connector through them.

 

Hope it helps !

Thanks Malhar thats an interesting way of looking at it. Will check it out.

Hi @Michael D​ 

 

your posted list of arguments is outdated.

Option "-P" is obsolete since ssms.exe version 18.0

 

SSMS version 22.x seems to have this option you need, I guess:

https://learn.microsoft.com/en-us/ssms/ssms-utility#syntax

 

But how this works, I do not know.

I am on this journey to establish a connection to Azure hosted SQL dbs too.

 

BR

 

 

  • 144 Views
  • 3 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!