Issue

It's not possible to select any tables from the schema while CDC is enabled.

Environment

Connector: SQL Server

Resolution

Please check to make sure the database user has the correct database role membership.

Make sure that you add the database user to the designated role you used when creating the CDC instance:

ALTER ROLE <rolename> ADD MEMBER <databaseUser>;

Cause

To easily manage the permissions in your databases, SQL Server provides several roles that are security principals that group other principals. They are like groups in the Microsoft Windows operating system. Database-level roles are database-wide in their permissions scope.

There are two types of database-level roles: 

1. Fixed-database roles that are predefined in the database
2. User-defined database roles that you can create.

For more information, you can view Microsoft's Database-level roles documentation.