Crystal 9 RAS on Windows 2003 Server

Posted on 2004-10-14
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?
Question by:gspronych
  • 5
  • 4
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:


Author Comment

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.

Here is a list of supported components

Supported components
Input FRS
Output FRS
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?
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:-(

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.


Author Comment

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.
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.


Author Comment

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. :(
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).


Author Comment

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
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.


Accepted Solution

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

Community Support Moderator

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

803 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