CDC fails when it executes the statement:
(Ensure that the current database is not master, but rather the current database for CDC when executing above command).
it returns no results.
Results are expected for any time when microsoft distribution is
enabled. Could it be that the ms sql server internal metadata is
corrupted after fail over? The customer may be able to disable/enable
distribution for this server if needed.
Please note that disabling/enabling replication may require a full refresh of the tables .
Run the following from SQL Server environment :
Please check into :
1. Ensure that the current database is not master, but rather the current database for CDC.
2. ensure that the connection is done with the same user as CDC.
3. Ensure that the problem still happens in CDC. If a problem happens once for instance configuration it is cached.
If the problem is resolved the instance needs to be restarted.
4. try using a third party JDBC tool to connect to the database similarly to CDC and execute the statement.
6. Disable/enable distribution and restart CDC afterwards. Try creating a
new instance until it succeeds. No point in creating subscriptions,
as they will be hitting the same problem.