I have a report package that consists of five reports. When I execute the package manually, all of the reports succeed and they are emailed as expected. I have them scheduled to run each day, but every time they fail with the following error:

Logon failed.
Details: 28000:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

I know that the sa password is correct, and I know that the reports work when I execute the package manually. Any ideas to why they fail on the schedule?

Thanks in advance.

Hi,

Are you using the latest build of CRD? Also which scheduler are you running?

The build I am running is:
6.1 Build 20070321/100

How to I know which Scheduler I am using? It is a daily schedule - what else would you like to know?

Go to Options-Scheduler.

Hi,
Can you check the following:
- make sure you are using a System DSN to connect to your database.
- if you are using SQL authentication make sure you are also entering this information in report options for the schedule.

HTH