Error in Schedule requires logon

[bhp]

I have a report (includes sub-reports) that runs fine when viewed on demand, but errors on scheduling.
There is a user name and password that work in the database tab. Does anyone have any suggestions.
I am using CE9

 

[Turkbear]

Hi,
What error? What Database?

What accounts are the Pageserver and Jobserver running under?

 

[bhp]

error message: "Unable to connect invalid logon parameters"
This is when you scheuld to run as Crystal Report, if you schedule to Adobe it is fine. Runnig against SQL 7 DB.
Thanks - James

 

[ShortyA]

Are you scheduling it to email or FTP elsewhere ? Do all your reports have this behaviour ? If not, are there any other reports that run from this SQL database ? Ask Turkbear mentions, are the page server, job server and output file repositories all running on the same user account ?

ShortyA

 

[bhp]

Thanks just happens at present on the one report, loads of other reports use this odbc successfully on schedules. It works scheduling to Adobe!