Add better exception handling to Data Management Gateway
When using Data Management Gateway to connect to on-prem SQL, errors returned by SQL Server explaining why connections weren't successful during credential setting aren't being surfaced. This makes it hard to troubleshoot problems with Data Management Gateway.
In ADF V2 we have done lots of improvements to better handle exceptions and to surface clearer error messages. Please try out ADF V2 and let us know what you think!
Thanks for the great feedback. We are working to add better exception handling to Data management gateway that will allow you to test the connection to your linked services.