Crystal Reports 10 Compatibility with Windows Server 2008 R2

[Former Member]

Hello I'm a developer and I'm in the process of migrating my ASP.NET application that uses crystal reports 10 from a win2k3 server to a win2k8 R2 server.

First of all, is CR 10 compatible with windows server 2008 R2?

The application is up and running on the new server, the only thing that fails is the reports. I get the following error message:

Error in file ....c:\windows\temp\{TEMP_FILE_NAME}.rtp

Failed to create the Crystal Query Engine.

This occurs at report.load(..)

I did already grant NETWORK SERVICE access to Temp and ran the CR redistribute msi that came with Visual Studio 2008 - CRRedist2008_x64.msi.

Please help

[former_member183750 · Accepted solution]

Assumption here is that when you say CR version 10, you mean version 10.5 (e.g.; the CR referenced assemblies are version 10.5.3700(?)).

That being the case, then yes this version is supported on WIN 2008. See [this|https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=56787567] wiki for more details. However, you should be on SP 1:

https://smpdl.sap-ag.de/~sapidp/012002523100010010692008E/crredist2005_sp1_x86.zip

Runtime:

[CRRedist2008_ia64.msi|https://smpdl.sap-ag.de/~sapidp/012002523100006255262008E/CRRedist2008_ia64.zip]

[CRRedist2008_x64.msi|https://smpdl.sap-ag.de/~sapidp/012002523100006255272008E/CRRedist2008_x64.zip]

[CRRedist2008_x86.msi|https://smpdl.sap-ag.de/~sapidp/012002523100009351342008E/CRBasicVS2008_redist_x86.zip]

- Ludek

[Former Member · Accepted solution]

Hi Ludek, sorry for having this in multiple places.

Anyway, yes, CR 10.5.3700.0 - the one that ships with visual studio 2008.

Thanks for the wiki, i've been looking for something like this for a few days now.

I'm a little confused, are you saying I should run CRRedist2005_x86.msi (contained in crredist2005_sp1_x86.zip) on the target 2008 server?

It's a 64 bit server though, and I did run CRRedist2008_x64.msi (that you listed under Runtime).

Also, as you recommended in the other thread, yes I did also try to register crqe.dll manually - it registered successfully but I still have that stupid error looking at me when I try to run a report.

[former_member183750 · Accepted solution]

If the app is compiled as 32 bit, use [this|https://smpdl.sap-ag.de/~sapidp/012002523100009351342008E/CRBasicVS2008_redist_x86.zip] 32 bit MSI - irrespective of the OS being 32 or 64 bit.

If the app is 64 bit use [this|https://smpdl.sap-ag.de/~sapidp/012002523100006255272008E/CRRedist2008_x64.zip] 64 bit MSI.

Do not compile the app as "Any CPU".

If this is a 32 bit web app, and you are on a 64 bit OS, you will have to run the app pool as 32 bit. But that is not why you are failing to load the crqe.dll (query engine). I just meant this as an FYI.

Perhaps if you are sure the correct runtime is installed, it will be a good idea to use the [Process Monitor|http://technet.microsoft.com/en-ca/sysinternals/bb896645.aspx] utility to see where the app is hunting for the crqe.dll.

- Ludek

[Former Member · Accepted solution]

I ran Process Monitor and saw that I was getting ACCESS DENIED .. it was looking for crqe.dll in the right place though, so I granted permission to the entire Business Objects folder but now I'm getting a new error.. but atleast it's past report.load..

New Error:

Unknown Query Engine ErrorError in File C:\Windows\TEMP\{TEMP_FILE_NAME}.rpt:

Unknown Query Engine Error

This occurs at:

report.ExportToHttpResponse

I feel like I'm almost there, any ideas on this error? Thanks for your help so far btw, I really appreciate it.

[former_member11696 · Accepted solution]

Great... now we are back to 32 or 64 bits. If your app is compiled for 64 bit then it requires IIS to also be running in 64 bit mode as well as the database client must also be installed and support 64 bit connectivity. Be sure to also set the app pool for the correct framework for your app.

Same for a 32 bit app only IIS must be running in 32 bit mode and the DB drivers must also be 32 bit mode.

Need more info now, run PM again and now look for errors around the DB driver and client you are using.

Use a third party tool to verify you can connect to the server, make sure it is running in 32 or 64 bit mode which ever you app is running in.

Thank you

Don

[Former Member · Accepted solution]

Well I think we've narrowed the problem down to CR and the database.

I created a blank report that has no query and it works! I then went back and added a simple select command and it went back to the Unknown Query Engine Error.

Ran Process Monitor and saw ACCESS DENIED for C:\Program Files\Common Files\System\ado\msado15.dll

Granted permission to that and now let another new error:

Logon failed.

Details: ADO Error Code: 0x

Source: ADODB.PropertiesError in File C:\Windows\TEMP\{TEMP_FILE_NAME}.rpt:

Unable to connect: incorrect log on parameters.

.. Um.. what? I'm 100% sure that the login credentials im passing are correct. I think I'm going to see every possible freakin error this stupid thing can spit out.

[Former Member · Accepted solution]

YESSSS!!!! IT WORKS!!

Finally, after days of installing, uninstalling, setting permissions, crawling through process monitor output.. I finally have it working.

For anyone with the same problem, here's what worked for me:

• I had to use the 32-bit runtime

• set application pool to 32-bit

• grant the following permissions based on the different errors listed below:

Error in File UNKNOWN.RPT

-

---

- Give NETWORK SERVICE list permission on C: Drive, run a report, then remove NETWORK SERVICE from the list (weird, but works, and I had to do this every single time I setup Crystal Reports on a new computer so far).

- You might also have to set correct permission on 'Temp' if u get still get this error.

Error in file ....c:\windows\temp.rtp Failed to create the Crystal Query Engine -

---

- Grant correct permission to C:\Program Files (x86)\Business Objects (your path may vary) (For me it was giving Users Modify permission to Business Objects folder) Unknown Query Engine ErrorError in File C:\Windows\TEMP\.rpt:

Unknown Query Engine Error

-

---

- Switch application pool to 32-bit.

- Make sure Crystal Reports Runtime is 32-bit (CRRedist2008_x86.msi)

Thank you guys so much for all your help and sticking through this with me.

[Former Member · Accepted solution]

I had all of the same problems and did all the same steps but it still did not work for me

What I finally did was to change the user (Identity) on the Application Pool to Administrator. This fixed the problem while still using the 64 bit versions.

[former_member11696]

Moved to .NET SDK forum