Solved

Crystal 9 RAS on Windows 2003 Server

Posted on 2004-10-14
11
722 Views
Last Modified: 2012-06-27
I need to install Crystal 9 RAS (Report Application Server) on Windows 2003 Server.
I read on the business objects website that 9 is compadible, but no documents stating any issues with RAS, etc.

I have installed the software and the service is running, but IIS doesn't seem to reconigize Crystal (or it is blocking it).

Crystal doesn't show up in the Web Service Extentions
RPT is not mapped in Application Extensions either

When I attempt to execute the RPT from my ASP application I get the below error

HTTP Error 405 - The HTTP verb used to access this page is not allowed.
Internet Information Services (IIS)

Can anyone suggestion how I can get it to work, will it work?
Thanks
0
Comment
Question by:gspronych
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
11 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12310183
Do you have IIS 6, which ships with Win2k3?  Also, does the system database install with RAS?

IIS6 isn't compatible with CE9, which means it probably isn't compatible with RAS 9.  MSDE 1.0 isn't compatible with Win2k3.

Check out the following link:

http://support.businessobjects.com/library/kbase/articles/c2012552.asp

~Kurt
0
 
LVL 3

Author Comment

by:gspronych
ID: 12311095
I am using II6 on Windows 2003 Server.
The database is on another server (Windows 2000)

I'm not using Crystal Enterprise, rather Crystal Reports.
I've found this article that says CR is supported.
http://support.businessobjects.com/library/kbase/articles/c2013125.asp

Here is a list of supported components

Supported components
--------------------
Input FRS
Output FRS
APS
Cache Server
Event Server
Page Server
Report Application Server
Job Server
Web Component Server

Unsupported components
----------------------
IIS 6 as the web server

Which is real confusing; how can RAS and Web Component Server be supported and not IIS6 as the web server.

Do you have any suggestions how can I get my RPT to work on II6 and Windows 2003?
Do I need another version of RAS?
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12312590
I understand that you're not using Crystal Enterprise, but RAS is essentially 'Enterprise Lite'.  That's why the article applies.

The OS is supported, the web server isn't.  You either need to use a IIS 5 or another compatible web server or switch to Windows 2000, which ships with IIS 5.  Sorry:-(

~Kurt
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 3

Author Comment

by:gspronych
ID: 12360105
Thanks for you help Kurt, but there is a work around.

I ended up calling Crystal since this problem didn't make much sense.
Here is the solution

My problem was that my application was using URL reporting, not RAS.
URL reporting is supported by Crystal Enterprise, not RAS.
As you mentioned, MSDE (or equalivant SQL Server) is required to use CE. MSDE without SP2 is not supported on Win2k3, so I installed SQL 2000 with sp3 and was able to get CE installed.
Next, WCS needed to be enabled in IIS6, and RPT needed to be mapped in the virtual directory configuration.

I'm happy to report web reporting that web reporting  is now working on my Win2k3 box.
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12360373
So, to solve your issue with the web server compatibility, you upgraded to CE (10, I assume - 9's not compatible with IIS6)?  This isn't a workaround, its an entirely new solution ;-)

Glad to hear you've got everything working, now.  I think SQL Server 2k SP3 was the right move, since you couldn't use MSDE.

~Kurt
0
 
LVL 3

Author Comment

by:gspronych
ID: 12371432
Hi Kurt

I did not upgrade to CE 10, I used CE 9 on my Win2k3 server.
I had to do a manual install on Win2k3 to get CE9 to work.

Here is the step by step I followed to set it up

- Install CE9
- Uninstalled MSDE
- Install SQL 2000 and SP3 locally, or create a ODBC connection to a remote SQL server
- Modify the APS in the Crystal Configuration Manager, on the config tab click 'specify' and it will build the CE9 database
- Start the APS service
- Enable WCS in IIS6
- Map RPT in your project

So 9 is compadible with IIS, with this work around.
Out of the box it is not compadible, I couldn't find this information in a KB on their site which is a shame.
Instead it cost 200 USD to find out. :(
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12376794
From the Business Objects knowledge base article I linked to:


3: Web servers / Web Connectors by operating system
===================================================

Windows 2003 Server
-------------------

IIS 6, which ships with Windows 2003 Server, is not supported with CE 9. While Windows 2003 Server is supported as an operating system for CE components, it is not supported as a web server.

"Compatible" wasn't the right word.  You've been able to get your environment up and running by doing a ton of work that you shouldn't have to do for a solution that is completely unsupported by Business Objects.  As such, I wouldn't ever recommend running this in a production environment (either for you or a client).  How could you justify to your customers (internal or external) or management that you've created a production environment that is unsupported by the vendor.   You're basically on your own for any issues that crop up.  From my perspective as a manager/consultant whose administered multiple implementations, I'd say that your solution is unacceptable due to the maintenance and support risks.

I'd recommend installing CE10 on a clean server (NOT upgrading the current CE software) and moving forward from there.  If you do this, your solution will be:

1) up-to-date with the most current production version of the software
2) completely supported by the vendor

If you have a maintenance agreement with Business Objects for CE9, then you should be able to obtain CE10 for free.  If not, it comes with Crystal Reports 10 (different CE versions bundled with the respective CR versions).

~Kurt
0
 
LVL 3

Author Comment

by:gspronych
ID: 12381551
Thanks for you opinion Kurt, but IMHO I feel it is not a major work around.
The reason CE9 is not compadible is because of MSDE not because of an issue with CE9.

While I agree using a work around is not the best method to install software.
The CE representative I spoke with didn't hestiate recommending this fix.
I asked them if their are any sufficiant changes from CE9 to CE10, and they said no.

If budget concerns where not an issue I may have purchased CE10.
I work for a Canadian Health Region, where costs are always an issue.

If we had any intention of using CE10 or CR10 I would have been interested in upgrading.
We won't be upgrading until the next version of Crystal (version 10+).

Thanks again
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12382531
Once again, its not that its not compatible, its that IIS6 isn't supported.  Just because you get it to work, doesn't mean you should.  Best of luck to you.

~Kurt
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 12392850
Question PAQ'd
500 points refunded.

CetusMOD
Community Support Moderator
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question