Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Prevent Error 'Cannot read CDW Log...'

DTS Package Logs

How to Prevent Error 'Cannot read CDW Log...'

by  JohnBates  Posted    (Edited  )
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.
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top