I was looking into using a managed identity (App Registration) to authenticate TimeXtender with Azure SQL DB resources, but can't get it to work. I couldn't find much documentation on the support site either.
I created a login on the database using T-SQL. I can also login with SSMS using the Azure Active Directory - Service Principal method:
I'm trying by using the Active Directory Password Authentication method in the Connection Settings dialog.
Testing the data source in TimeXtender gives an non-specific error:
Service request failed: One or more errors occurred. (System.Exception)
Details:
Service request failed: One or more errors occurred. (System.Exception)
Module: TimeXtender.ODX.Engine
TimeXtender.ODX.Engine.ODXFaultException
at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequestuC,T](WcfServerSettings serverSettings, Func`3 func)
at TimeXtender.DataManager.EditDataSourceCommand.<Dialog_OnTestConnection>b__12_0()
at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)
Service request failed: One or more errors occurred. (System.Exception)
Module: timeXtender
TXModelInterface.ExceptionWrapperException
at TimeXtender.DataManager.ConnectingThread.HandleError()
at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions)
at TimeXtender.DataManager.ConnectingThread.ExecuteFastAction(String title, Action action, IWin32Window parentForm, CancelBehaviors cancelBehavior, ErrorBehaviors errorBehavior, String callerName)
at TimeXtender.DataManager.EditDataSourceCommand.Dialog_OnTestConnection(Object sender, EventArgs e)
Has anyone got this to work?