The report server has not gone nuts. What database are you using? Are you consistent on how you setup the security for each report?
in the CMC navigate to your published report.
Click the process tab
Click on database
on the bottom check
When viewing report:
Use same database logon as when report is run
Check the account the Job server runs under. This may be an issue if you are using integrated security. Does the account's password expire?
Do you have the same client software ODBC OLEDB on the Crystal server as you have on the workstation on which you create the reports. ODBC DNS the same?