I can’t answer the first part but I think the Azure SQL issue can be fixed by using the Official Microsoft JDBC Driver for SQL Server. You need install it, but it’s easy using then Install Extensions menu.
I use Azure SQL and KNIME without issues using this.