CE 10 Scheduling failure

[IanWaterman]

I am running a report against MS SQL Server, if I run report manually it runs OK from history tab. However, if I run via scheduler it fails, even when I click select Once with Run Now. When I select schedule it fails with the error

Unable to connect: incorrect log on parameters. File C:\Program Files\Crystal Decisions\Enterprise 10\Data\procSched\SRVCORS08.reportjobserver\~tmp133460ba5dc35b0.rpt.

Any ideas as to what I am doing wrong.

Thank you

Ian

 

[Turkbear]

Hi,
A scheduled report uses the CE jobserver's account to connect - be sure that account has sufficient rights to access the database and its location. - Best to use a domain account with those rights for all the servers, but especially the pageserver and jobserver.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[IanWaterman]

Hi

Seems it was a quirk of CE10. Sometimes the database connection details loses the password. Thus even though the password box is blank in Process- Database it still runs.

However, when you update the report via the Crystal Reports interface to CE you then have to re-enter the password.

When you update a report object and the password field is not blank all is OK.

Ian

 

[Turkbear]

Hi,
I administered CE10 from release to XI's release - I never saw it 'lose' passwords - however, if you have not unchecked the option to update the password when updating the report via CR then it will blank for security reasons..Check the docs for the specific method of setting your update options.

Also, be sure that you specify that the user/pass combo be saved when the report is published.





To Paraphrase:"The Help you get is proportional to the Help you give.."