Solved

Crystal 9 RAS on Windows 2003 Server

Posted on 2004-10-14
11
718 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
  • 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
 
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

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. …
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 …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now