Azure Active Directory - Universal with MFA Authentication for SQL Search
Would be good that SQL Search authenticated through Azure Active Directory - Universal with MFA.
SQL Search version: 3.4.2.2567
Error log:
[78] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list
System.Data.SqlClient.SqlException (0x80131904): Cannot open server "XXXXX" requested by the login. The login failed.
...at RedGate.SQLSearch.Addin.Tab.DatabaseConnector.OnlineDatabasesForInstance(String connectionString)
Error Number:40532,State:1,Class:20
[1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy
Exception: Exception has been thrown by the target of an invocation.
...at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler)
![](https://secure.gravatar.com/avatar/e3bc48a688d445e9bc8959146a8d163c?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Jacob commented
Could you provide an update on this issue?
-
Kyle commented
I saw that SQL Prompt has support for this auth as of v10.4.0.16033 (almost 1 year ago to the day). When might we expect SQL Search to also support it?