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.
We have already surfaced the diagnostic tab in the DMG Configuration Manager but we do intend to do more here.
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.