Hi all. SAP / Crystal / BO obviously think their product should work on Server 2008, but we are struggling.
A number of our customers have had varying degrees of success running Crystal, we are aware of the problems regarding CR_XI on 64 bit platforms and / or Windows 7 , so we have started investigating CR 2008, only to find similar problems.
To take our platform out of the equation, I created a one-page aspx web site with one Crystal report.
It runs fine on my Windows 7workstation. If I deploy it to a Windows 2008 server, it refuses to run (pointing to the same database).
I get "database logon failed" Nothing in the event log, no other errors in SQL server, or anywhere I can see.
If I set the property EnableDatabaseLogonPrompt="true" then the report displays the credentials panel, asking for Server, database, user name and password.
The server is correctly displayed, "ulster\ulster", and I can enter a username and password, but THE DATABASE field is blank and I CANNOT ENTER TEXT in it.
ON THE SAME MACHINE I verified that I can connect to the database with the exact same credentials.
Googling over the last few days, I see lots of people having major problems with all versions of Crystal on Windows Server 2008, and I found one site where the guy commented that Crystal needs to be able to read and write (and delete?) files in C:\Windows\Temp...!
I checked that folder, granted NETWORK_SERVICE full rights, and indeed i can see temp files being created there.
I suspect these problems are related to permissions (it usually is with Windows these days)
Can someone please detail exactly what permissions are required on what folders for Crystal to connect and run?