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.