SQL Server Error: Error Fetching Configuration: HTTP Error 502

Issue

While setting up a new connector, or clicking the Setup tab of an existing connector, the following error appears:

Error fetching configuration: HTTP error 502 while standard config for group_id_name
Failed to parse error response:  org.glassfish.jersey.message.internal.MessageBodyProviderNotFoundException:
MessageBodyReader not found for media type=text/html;charset=UTF-8, type=class
com.fivetran.http.exception_mappers.DefaultErrorResponse, genericType=class
com.fivetran.http.exception_mappers.DefaultErrorResponse.

Environment

SQL Server connector

Resolution

Make sure the SQL Server login you've specified for the connector has access only to the tables you would like to sync to your destination. Your DBA should be able to create a SQL Server account to limit the number of tables our connector can access.

Cause

If the credentials have access to thousands of tables, we will eventually time out trying to get the schema for all of those tables. If you intend to sync thousands of tables, we recommend you to split them into multiple connectors.