MFA for SQL Search

KVigor

SQL Search is inactive since my company switched to MFA SQL Azure. The mutifactor authentication seems to not be something that SQL Search can handle. How can I get SQL Search to work with MFA for Azure SQL?

Russell D

We had a chat about this and its something we'd like to do. It's not definitely a no, but please don't take this as a definite yes either. We're looking at consolidating the connection dialogue which would make the work easier so it may yet get done.

KVigor

Cool! And it only took 2 years. 😂

Much appreciated. Now I have to decide if I'll still use the tool? Been a couple years without it. 🤔

I'm grateful nonetheless.

Russell D

No current plans to add MFA support to SQL Search I'm afraid.

KVigor

Bummer.

KVigor

Thanks for the consideration and planning.

dufflepud

Is this still not on the road map?  I would imagine this is becoming more and more of an issue for people.
Creating an Azure App for all of our servers is outside the realm of possibility.  

DBTL

dufflepud said:

Is this still not on the road map?  I would imagine this is becoming more and more of an issue for people.

Certainly is for me.

Without support for MFA, I cannot condone the use of Redgate products to my clients anymore.

a.higgins

DBTL said:

dufflepud said:

Is this still not on the road map?  I would imagine this is becoming more and more of an issue for people.

Certainly is for me.

Without support for MFA, I cannot condone the use of Redgate products to my clients anymore.

Echoing this sentiment, it's been great to see MFA added to several other Redgate products but this one is a really useful feature that's unfortunately no longer available to us. 

ostandage

Hi all,

Support for Azure MFA connections has now been added to SQL Search, for more information see the release notes: https://documentation.red-gate.com/ss3/release-notes-and-other-versions/sql-search-3-6-release-notes

You can download the latest version from here: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe

Thanks,

Owen