Forum Discussion
SQL Server CDC Mirroring – Internal System Error on Init/Resync
I profiled the activity on the MSSQL side to understand what Fabric is sending. It appears that the pool script has changed and is now using DMVs or system tables that require elevated permissions.
On our side, we have adjusted the configuration to avoid granting sysadmin, as this led to unintended side effects. In particular, it caused automatic addition of tables to the source that should not have been included.
This is the right which one resolved this issue. The problen has been discussed with microsoft also
VIEW SERVER STATE
Thank you for confirming the fix and sharing the details. It's useful to know that granting VIEW SERVER STATE resolved the issue.
Your feedback will help others avoid similar problems. Thanks for sharing the solution with the community.