On-Premises SQL Server Mirroring: Internal system error occurred. ArtifactId: 8190a71d-9f0b-46c1-a3b

Hi!

I have found the issue:

select
name,
is_cdc_enabled
from sys.databases;
EXEC sys.sp_cdc_enable_db

returned that CDC is not enabled for the DB.

When trying to enable it with:

EXEC sys.sp_cdc_enable_db

it failed with

Could not update the metadata that indicates database pstDemo is enabled for Change Data Capture. The failure occurred when executing the command 'SetCDCTracked(Value = 1)'. The error returned was 15517: 'Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.'. Use the action and error to determine the cause of the failure and resubmit the request.

This I fixed with

ALTER AUTHORIZATION ON DATABASE::[pstDemo] TO [sa];

 
Afterwards I was able to enable CDC and the mirroring started working.