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.