Sign up ×
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's 100% free, no registration required.

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?

share|improve this question

migrated from Apr 8 '13 at 14:43

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 2 down vote accepted

dbo is mapped to an invalid login. Re-map it to a valid one:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.