Can confirm that @Sarath solution works. Had no issue with testing other sources like Azure Data Lake Gen2 but when I added an Azure SQL DB as a source it gave me this cryptic error.

Glad I found this, otherwise I would have never known how to fix it. It's absolutely insane to me how Microsoft hasn't fixed this yet.