A really wierd thing happened this

[katenorster]

A really wierd thing happened this morning to us. Yesterday all was fine with people being able to run reports off no problems. This morning however, we get the logon screen asking for the user and password (as usual) but when you click on "Logon" for the Crystal Enterprise Logon, the screen flickers and nothing happens.
Now we can't onto the server to look at the manager stuff. It is as if the user "administrator" has been removed.

Nothing installed or changed recently.

Everything apart from CR works. We had the problem initally this morning, stopped and restarted the CR services. This didn't help so we restarted the server. Still didn't work. Tried stopping and restarting the CR service again but the APS service won't start, giving us the error :

Could not start the APS server on the local computer - this service did not return an error. This could be an internal windows error or an internal service error.

Other services on the server have been stopped and started again successfully also.

Any help would be much appreciated

TIA

Kate

 

[RoughingIT]

To get going again without much troubleshooting I would backup Input/output, APS database (access or SQL server) and uninstall and reinstall CE alone.
Or, to find out what's going on, try to create a new APS database and run off that. If you use an Access db, back up the ce8.mdb, if you use MSDE (SQL server), create a .bak file of the db. Then go to the Config Manager, properties of APS, lasttab, specify and create a default database. This step will blow your existing db out, so see above for backup.
See if the APS starts then.

 

[chelseatech]

Check you are not low on Disk space on the drive with yoru TEMP files (usually C drive). The APS checks this and stops if it hasn't got room to work. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[bmitchel]

if you are using sql, did your dba or network guy change access rights to the ce8 (APS) database. go into Crystal configuration manager - aps - then make sure that the correct account and passwords are being used.

you might also want to look at event view - application for any errors. you'll probably see that the aps service can't start because of a rights issue.

hope this helps. this has happened to us and this is what we did to fix it.

 

[Clapper]

I had this problem myself and discovered that the problem was TCP/IP filtering of port 6400. By default the crystal APS service is configured to use port 6400 (unless you suggest otherwise). If by chance your I.T. department administered port filtering on the network, you would probably not realize this? I had port filtering software installed on the server and I had removed this software to get the APS service to work. I am also using Windows 2000, therfore I decided to enable TCP/IP filtering for my LAN connections (blocking everything but port 80) and this reproduced the problem to confirm my findings.

Hope this helps!

Chris