Unstable extract from Synapse Serverless SQL Pool (Business Units)

We have a Dynamics 365 Finance and Operations system, where we have the Data-lake export running (for over 1 year). THe setup is similar to Josephs sketch solution for the following question:
Dynamics 365 F&O Data Lake as a TX source | Community (timextender.com)
We have it running quite stable on one of our boxes, but are struggling with stability on a pre-production box.

The goal is to use Azure AD Integrated Authentication, and the user running the scheduler has been given access to the Serverless SQL Database (tested in SSMS)

First we experienced some missing prerequisites when using Azure AD auth:

Execute ODX d365fo_dl.ACOJournalTable_BR ADO.NET Transfer:Error:Failed
      -Execute ODX d365fo_dl.ACOJournalTable_BR ADO.NET Transfer 'Failed'
          Unable to load adalsql.dll (Authentication=ActiveDirectoryIntegrated). Error code: 0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072
          
          Details:
          
          SQL Server: 'import-d365fo-datalake-ondemand.sql.azuresynapse.net'
          SQL Procedure: 'InitADALPackage'
          SQL Line Number: 0
          SQL Error Number: 0
          
          Unable to load adalsql.dll (Authentication=ActiveDirectoryIntegrated). Error code: 0x2. For more information, see http://go.microsoft.com/fwlink/?LinkID=513072
          Module: .Net SqlClient Data Provider
          System.Data.SqlClient.SqlException
             at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
             at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
             at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
             at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
             at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
             at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
             at System.Data.SqlClient.SqlConnection.Open()
             at TimeXtender.DataManager.DataSource_Sql.NewSqlSourceConnection(String catalogOverride)
             at TimeXtender.DataManager.DataSource_Sql.SourceConnection()
             at TimeXtender.DataManager.StepTransferSSISExecute.BulkCopySource(Boolean executeIncrementalLoad, DataSource dataSource, VariableResolveObject dynamicResolveObject)
             at TimeXtender.DataManager.StepTransferSSISExecute.DoStageDataSource(Boolean isIncrementalAllowed, DataSource dataSource, StepSetup stepSetup, VariableResolveObject dynamicResolveObject, Boolean loadPrimaryKeysOnTransfer)
             at TimeXtender.DataManager.StepTransferSSISExecute.DoStage(StepSetup stepSetup, VariableResolveObject dynamicResolveObject)

This was resolved by installing the latest SSMS (Please provide input on better solution, if you think this is the cause of the problems).
 

Currently we are struggling an ADALException, which seems to originate from the connection process.

Execute ODX d365fo_dl.d365_DimensionAttributeLevelValue ADO.NET Transfer:Error:Failed
      -Execute ODX d365fo_dl.d365_DimensionAttributeLevelValue ADO.NET Transfer 'Failed'
          One or more errors occurred.
          The request has timed out.
          
          Details:
          
          The request has timed out.
          Module: System.Data
          AdalException
             at ADALNativeWrapper.ADALGetAccessToken(String username, IntPtr password, String stsURL, String servicePrincipalName, ValueType correlationId, String clientId, Boolean* fWindowsIntegrated, Int64& fileTime)
             at System.Data.SqlClient.ActiveDirectoryNativeAuthenticationProvider.<>c__DisplayClass2_0.<AcquireTokenAsync>b__0()
             at System.Threading.Tasks.Task`1.InnerInvoke()
             at System.Threading.Tasks.Task.Execute()
          
          One or more errors occurred.
          Module: mscorlib

Please provide any trouble-shooting guidance on the issue, as this prevents us for rolling out our TX Based DWH.

Thanks in advance.