Al_Ko
Registered: 10/16/09
Posts: 1
|
| | 10/16/09 at 11:37 PM | Reply with quote | #1 |
|
Hi everybody,
Just went through the hassle of moving an ISD application from W2003 Server 32-bit to Windows 2008 64-bit.
Want to share the solution.
Application was working fine on W2003 but after moving to W2008, Crystal Reports (export into pdf) stopped working, giving error "Unable to access data. Please contact your system administrator or customer support."
Version of Crystal CRXI SR2.
Currently Crystal does not support CRXI SR2 deployment on 64-bit. So,
1. I downloaded the latest Net Server distribution from
http://www.sdn.sap.com/irj/boc/downloads , pay attention it does not work with IE8, I used Firefox. (Crystal Reports XI Release 2 - FP 5.5 .NET Server Install direct link https://smpdl.sap-ag.de/~sapidp/012002523100011605522009E/crxir2_fp55_net_si.zip)
2. After installation, I copied CrystalDecisions.CrystalReports.Engine.dll, CrystalDecisions.ReportSource.dll and CrystalDecisions.Shared.dll from C:\Program Files (x86)\Business Objects\Common\3.5\managed\dotnet2
into bin folder of my application
3. Modified xml files in the application for the pages that contain reports, so the reference to dlls shows C:\Program Files (x86)... instead of C:\Program Files i.e.
C:\Program Files (x86)\Business Objects\Common\3.5\managed\dotnet2\CrystalDecisions.ReportSource.dll
This was done for all 3 dlls
4. In IIS7 went into Application Pools, choosed pool for my application/Advanced Settings and set Enable 32-bit application to True.
My application has a separate pull with Managed Pipeline Mode-Classic (if double click on the pool) and Identity=NetworkService (in Advanced Settings).
I suspect that it could work without steps 1-3. So, start with step 4 and if it does not help, do 1-3.
Also do not forget to grant read/write permisson on Windows\Temp folder to Network Service.
Hope it will save somebody's time.
Al
|
| Loading... | |
JimiJ
MVP Developer
Registered: 03/31/05
Posts: 4,028
| |
vksohpaul
Registered: 06/16/10
Posts: 1
|
| | 06/16/10 at 04:08 PM | Reply with quote | #3 |
|
Thanks a lot for your help. We also had similar problems in deploying Crystal Reports based application on Windows 2008 server built using 32 bit (x86) setting and was not working. We created an application pool with the following setting and assigned it to our .net (VS 2008) web application in order for it to work
1. Enable Windows 32 bit application = True (By default it is false)
2. Application must run under "Network Service" account
Thanks
Vikram Sohpaul
|
| Loading... | |
RSS(.NETCodeGenerationIsHere).gif)
