This error is caused Intermittently by the Log reader agent in the transnational replication. When you observe the error, the database principal ‘dbo’ associated to the login mapped to the ‘dbo’ user cannot be impersonated. The database owner or login associated to ‘dbo’ user are not ‘sa’ but other windows authentication/SQL authentication login.
- Stop the Log reader agent
- Change the ownership of the database using the below query:
ALTER AUTHORIZATION ON DATABASE::Databasename TO sa; GO
3. Restart the Log Reader Agent.
It is always advisable to map the ‘dbo’ user of the login to ‘sa’ to avoid the intermittent issues with Log reader agent in Transnational Replication.