Take the 2-minute tour ×
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 stackoverflow.com Apr 8 '13 at 14:43

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

    
Voted to close as off-topic (belongs on dba.stackexchange) not because I think it's a bad question but because I think you'll get a much better answer at the dba site. –  Joel Coehoorn Apr 8 '13 at 13:30
    
Under what account does your SQL Agent run? My guess is that it's the NT AUTHORITY\NETWORK SERVICE you mentioned. I'd suggest changing that to an explicit account. Failing that, add that account to the db_owner role in the database. –  Ben Thul Apr 8 '13 at 15:44

1 Answer 1

up vote 1 down vote accepted

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

ALTER AUTHORIZATION ON DATABASE::[<dbname>] TO [sa];
share|improve this answer

Your Answer

 
discard

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.