I have setup Crystal Reports Server 2008 on Microsoft Windows Server 2003 SP2. Oracle 9 is currenlty installed on the server and the TNSNAMES.ORA file has been configured so that it points to the correct server. The ODBC connection has been setup on the Server, I have tested the connection on the server and it works fine.
CMC is running fine, we currenlty can get SQL reports to work in it no problem. However I cannot get a Crystal Report created in Crystal Reports 2008, that is connecting to an ORACLE database to work.
When I add the report to the server, and try to view it on run it, I get the following error:
"Error in File ~tmp1d6c5ecca060440.rpt: Unable to connect: incorrect log on parameters"
I have tried playing around with the Database Configuration in CMC I get the same issue. I have also checked all the Servers in CMC and they are Enabled and running.
I dont know what else to do? Is there something that I am missing?
Your assistance is greatly appreciated.