When I enable CDC (Change Data Capture) on an Azure SQL Managed Instance, it initiates a reboot, and upon coming back online, I observe that CDC is not Enabled. I'm curious about the reasons for this reboot and why CDC isn't installed properly. How can I overcome this issue?
It gives the following error and reboots:|
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
What might be causing the reboot, and what steps can I take to ensure that CDC is Enabled successfully on the Azure SQL Managed Instance without the need for a reboot?