[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2706
  • Last Modified:

Crystal Reports Server install...compatibile with Windows Server 2008 R2?

I haven't worked with Crystal Reports in a long time but now we have purchased 5 user licenses of Crystal Reports and are ready to install the server version and 5 client desktop versions and need some deployment advice.  We are using a SyBase SQLAnywhere database on a overutilized Windows Server 2003 server ("serverA2003").   But we now have a new fairly beefy Windows Server 2008 R2 to use ("serverB2008") which will also need to function as a DC/global catalog server for this office of about 40 users.  We could either
1) install CRS on serverA2003 but first migrate some applications to serverB2008 to lighten the load but which may be a process too long and painful .
2) install CRS directly on the new serverB2008 to hit the db on serverA2003, not ideal as its an important Windows DC server.    
3) install CRS on an OS platform of choice on hyperv on the new serverB2008 to hit the db on the serverA2003, but then we have to purchase another windows server license .

So questions are:
a) Anybody with experience with CRS...what's the best advice with existing setup?
b) Is CRS compatible with Windows Server 2008 R2?  This technical doc doesn't list 2008 R2, but I think its outdated as of August, 2009.
c) In terms of resource utilization, how bad is it these days?   Do most people put CRS on a dedicated server anyway?   However, we won't have that option unless we go the need to go the hyperv route.  And serverB2008 has to be a DC and global catalog server among other services.
  • 4
  • 2
  • 2
1 Solution
zephyr_hex (Megan)DeveloperCommented:
i don't think IIS will install on a DC, and as i recall, crystal server needs IIS.

installing IIS on a DC is a security risk.
thefumblerAuthor Commented:
I didn't realize crystal server needs IIS, but yes I know IIS can be installed on a DC....for example WSUS runs under IIS.  In SBS where everything is on one server that happens all the time.   I know installing IIS on a DC is not recommended for security reasons but in this situation it is only for internal use.   And since this is a fairly small office, the performance impact of just IIS shouldn't be too bad, but do you know about Crystal's impact?  
zephyr_hex (Megan)DeveloperCommented:
i can't speak to CRS specifically,
but the main "impact" of any database driven app should be the database.  which means, you should make sure your db server is the powerhorse.
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.

thefumblerAuthor Commented:
ok, I'm looking for someone who knows CRS.  
Kurt ReinhardtCommented:
Crystal Reports Server 2008 SP3 (the latest full build you can download from SAP) is compatible with Windows Server 2008 R2.  I just installed one last week and I'm on site this week installing BusinessObjects Edge Series 3.1 SP3 (the  middle tier product) on R2.

There are definite caveats, because R2 is 64-bit only.  For one, if you use IIS AND you want to use SMTP, you need to configure SMTP through the IIS 6 configuration manager, not IIS 7.  The actual web server components, however, will be managed through IIS7.

Also, I generally recommend installing Crystal Reports on the actual application server for future potential troubleshooting, but you MUST install it prior to Crystal Reports Server due to shared .dlls that might overwrite your CRS .dlls if it's installed after.  Since the purpose of the machine is to be used for CRS, you'll want to ensure it's using the right .dlls.

In general, I would highly recommend you not install any application server on your DC.  It's bad mojo.  My preference would be to buy a well sized dedicated machine that will serve as both the web server and application server for Crystal Reports Server.  You can install in a VM (I personally haven't used HyperV, but I've installed to other VMs) and there are "gotchas" there, too.

Lastly, I would also highly recommend you not install Crystal Reports Server on the same machine that houses your actual reporting data database.  That's because you're going to be cannibalizing resources from one application to serve another.

FYI - to the best of my knowledge, that's not the current build available from the SAP Service Marketplace for Crystal Reports Server.  When I downloaded it last week, it was in three parts (1 .exe and 2 .rar files), which is consistent with every download I've done.  There was a single file download a month or two ago, but it was faulty and was pulled.

In summary, I would consider buying a small small dedicated server for Crystal Reports Server 2008 V1 SP3.  You'll need to size it, of course, so that it can meet your needs, but at minimum, I would consider at least a dual core processor, 4GB RAM and 100 GB Disk space. That's basically what I consider a minimum-spec machine for CRS.

thefumblerAuthor Commented:

Thank you very much for your response.   I'm thinking of doing the virtual server route and purchasing a windows license because I can add memory to the host if needed but its a decent newer HP server with a ton of disk space.    Because I get lost at SAP Market Place, would you you mind checking what the actual files should be that I need to use?
Kurt ReinhardtCommented:
The files you're going to need will be called:


Within the SAP Service Marketplace (which I hate, btw), you'll find them as follows:

1)  Click on "Software Downloads"
2)  Click on "BusinessObjects Downloads"
3)  Click "Browse the BusinessObjects SAP Portfolio"
4)  Click "Installation and Upgrades"
5)  Click "Crystal Reports Server"
6)  Click "Crystal Reports Server 2008 V1"
7)  Click "Installation and Upgrade"
8)  Click "Windows"
9)  Download the files listed above

When you purchased Crystal Reports Server, did you purchase the Dashboard Designer Starter Package or an Crystal Reports Dashboard Design software? Are you interested in using LiveOffice in conjunction with Crystal Reports Server?
thefumblerAuthor Commented:
I looked up those packages briefly....I believe we have basic needs as we just need to replace functionality from a (much) older version.  thanks

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now