Crystal Enterprise won't run report for remote web browser

Hello Experts,
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.

ChrisHelveyAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
ChrisHelveyAuthor Commented:
And another thing:
I cannot run the Crystal Management Console. I get a 404 file not found error on this URL:
http://fps02/crystal/enterprise/admin/redirect.csp 

(FPS02 is the name of the new server as well as www3)

It has the same files in that directory as the other server... I assume this has something to do with .csp registration, but I have done that and it shows up pointing to the correct .dll in IIS manager home directory tab. Soemthing tells me this is all related to why it doesn't work. I need to find out how this Crystal .dll registration works or how to verify it is in fact registered.
0
 
ChrisHelveyAuthor Commented:
I found a Crystal document telling how to check the registered .dlls for IIS. I am going to follow that, along with making sure the IUSR_FPS02 has sufficient permissions everywhere necessary according to the Crystal document published specifically about security permissions with Enterprise. Will follow up.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
ChrisHelveyAuthor Commented:
Still no luck. I have added the script map key in the registry per the cr8_winsapi-Version8.pdf document from Crystal with .rpt, csp, cwr, and .cri and made sure the extensions in iis mgr show the full path name with quotes around them "C:\Program Files\Seagate Software\WCS\wcsinsapi.dll" for all the above extensions as well.
Then rebooted.
No audit security failures in the event log show up. So I don't think it's permissions.
I still get 404 File not found whenever it tries to access the .rpt (or the http://fps02/crystal/enterprise/admin/redirect.csp for that matter.)

I'm lost and don't know where to go next....what else can I check?
0
 
ChrisHelveyAuthor Commented:
So, in IIS mgr. Should the registration for the dlls be in short format as the document says, or the long format with quotes? Currently in long format with quotes.
0
 
ChrisHelveyAuthor Commented:
And here is the log from IIS when trying to access the .rpt file:

#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
#Date: 2007-08-09 20:21:39
#Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2007-08-09 20:21:39 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 301 0 0
2007-08-09 20:21:39 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/Default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:21:39 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/redirect.csp - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:35:38 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:35:38 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/redirect.csp - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:38:07 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/redirect.csp - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:38:16 W3SVC1 10.0.0.2 GET /Default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:38:18 W3SVC1 10.0.0.2 GET /lumber_reports.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:38:19 W3SVC1 10.0.0.2 GET /lumber_tally.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:38:21 W3SVC1 10.0.0.2 GET /lumber/lumbertally.rpt user0=sysdba&password0=masterkey&init=actx 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:38:43 W3SVC1 10.0.0.2 GET /lumber/lumbertally.rpt user0=sysdba&password0=masterkey&init=actx 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:38:53 W3SVC1 10.0.0.2 GET /lumber/lumbertally.rpt - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:40:10 W3SVC1 10.0.0.2 GET /Default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0
2007-08-09 20:40:12 W3SVC1 10.0.0.2 GET /lumber_reports.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0
2007-08-09 20:40:13 W3SVC1 10.0.0.2 GET /lumber_tally.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0
2007-08-09 20:40:13 W3SVC1 10.0.0.2 GET /lumber/lumbertally.rpt user0=sysdba&password0=masterkey&init=actx 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:44:38 W3SVC1 10.0.0.2 GET /Default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:44:41 W3SVC1 10.0.0.2 GET /lumber_reports.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:44:42 W3SVC1 10.0.0.2 GET /lumber_tally.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:44:46 W3SVC1 10.0.0.2 GET /lumber/netshort.rpt user0=sysdba&password0=masterkey&init=actx 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
0
 
ChrisHelveyAuthor Commented:
I am seeing in the Crystal log that it is referring to my old server (IWPNT4) .
Where does this come from. Still getting 404 Page or directory not found.

Anyone?
0
 
ChrisHelveyAuthor Commented:
Here is the piece from the log:
2007-08-08 19:06:33 156 658 /crystal/enterprise/admin/en/infoobject.cwr?action=%2D10005%26id=123%26WCSLOGONTOKEN=IWPNT4%253A3C7B3C63AC5E4AE0971850492B99AFF0
2007-08-08 19:06:33 0 828 /crystal/enterprise/admin/en/infoobject.cwr?action=%2D10005%26WCSLOGONTOKEN=IWPNT4%253A3C7B3C63AC5E4AE0971850492B99AFF0%26cmd=path2%26id=123
0
 
frodomanCommented:
Can you get into the crystal management console?  If so, have you checked manage servers to make sure everything in there is pointing to your new server?
0
 
ChrisHelveyAuthor Commented:
I still can't access the management console. I get 404 Fiie not found on http://fps02/crystal/enterprise/admin/redirect.csp  .

Anything .csp does not work. I have checked the registrations in IIS and tried them as short file names and long file names with quotes and with complete reboots in between. I also checked the registry and added the script map key with .rpt ..csp,. cwr. and .cri as stal document is stated in the documentation for troubleshooting the Web connector.

Still lost. I think I will now try another re-install, but I really think the problem is in the IIS registrations for the crystal web connector. Is there anyway to KNOW if the .dll is registered?
0
 
ChrisHelveyAuthor Commented:
Solved myself. In Windows 2003 IIS you need to "allow" specific ISAPI filters to run. Done in the management console.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.