Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am having a problem running the CDC change capture job against some of my test databases.
The error message I'm getting is the following:
Executed as user: NT AUTHORITY\NETWORK SERVICE. 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. [SQLSTATE 42000] (Error 15517).
How can I fix this?
dbo is mapped to an invalid login. Re-map it to a valid one:
ALTER AUTHORIZATION ON DATABASE::[<dbname>] TO [sa];
Under Security, add the principal as a "SQL user without login", make it own the schema with the same name as the principal and then in Membership make it db_owner.
