SQL Server 2000
Situation:
When the user tries to open the log for a DTS Package, they get error ........
"CDW Cannot read CDW Log from the destination server".
Solution:
This is usually a permissions problem. The package logs are stored in the msdb database. Even if the user is the owner of the DTS package, they may not have the necessary permissions in msdb.
Within the msdb database:
1. add the user to the database
2. Grant db_datareader permission to the user.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.