Crystal Enterprise won't run report for remote web browser
Posted on 2007-08-09
I have a problem with Crystal Reports Enterprise and need some guidance. Here is what I have:
We have an aging server that I am replacing that currently runs Crystal Reports 8.5 and Enterprise version 8. Users access the Crystal Reports via a web browser pointed to www2.ourdomain.com where www2 is the file server I am replacing. It works fine and has for years. It is the default web server in IIS and basically the reports sit in a folder under wwwroot. example: wwwroot\lumber\reportname.rpt and the web pages organizing them for the user are super simple html pages.
The new server is a member of the domain and an ADS "secondary" at the moment and everything else on it is working fine. It has DNS and is a secondary to the old server's DNS, and is pointing to itself for DNS resolution. It is called www3 and shows in DNS properly.
THE PROBLEM: In short, when accessing the report, it would open it up in Crystal Reports instead of running. I then found out I needed to register the ISAPI extensions on this web site for .cri,.csp, cwr,. and .rpt to the file wcinaspi.dll which I did (and rebooted.) Now I get a 404 "File not found" when trying to access the .rpt file from the web page.
IUSR_FPS02 is the user for anonymous access and for troubleshooting, I have given full control access to the root of wwwroot for this user.
In an attempt to make the Crystal service work like the old one I have done the following:
Installed Crystal Reports 8.5
Installed Crystal Enterprise 8
Copied the files from the old server inetpub\ wwwroot along with subdirectories to the new server.
Ran the report wizard without errors.
Registered the ISAPI dlls in IIS mgr and rebooted.
Double checked security permissions on \inetpub\wwwroot and subfolders (and report files.)
Checked that the Crystal Services are running (they are.)
Made the settings in IIS to be the same as they are on the old server:
Made sure any paths in the htm pages point to www3 instead of www2 (only a few.)
Double checked to make sure my Data Connector is correct (it is - I can access the Interbase database fine from other programs.
Made sure the report files really are where they are supposed to be (\inetpub\wwwroot\lumber )
Properties under iis mgr say that this server is running an old version of server extensions 2002, so I downloaded and applied and rebooted but it didn't make any change (even in iis mgr. I don't think it's related but thought I'd throw that in.)
As you can see, I am a networking guy, but I don't know JACK about Crystal reports. Any guidance will be appreciated.