I am unclear on some of this - We have everything installed now and I am
able to Login To my ARWEBREPORTVIEWER on my Business Objects Server and
I can login to my Mid-Tier Server.
But, not sure what I should put where.
ARWEBREPORTVIEWER Configuration Page.
Reporting Working Directory - Is this the location of the reports folder
on the BO server for the ARwebreportviewer?
Machine Name - Name of the Business Object server that we installed the
arwebreportviewer
Machine Connection Details - Business Objects Enterprise XI
AR System ODBC Data Source Name -- ????
CMS Folder Name - ????
CMS user Name -
Then on the Mid-Tier Report Settings
We Choose BOXI/CRYSTAL Report Server 11 on a different machine w/o a
Midtier
Reporting Working Directory - What directory goes here
BOXI/Cyrstal Report Server 11 Location - address of the Business Object
Server
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of strauss
Sent: Tuesday, September 11, 2007 1:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Running mid-tier reports on Business Objects Enterprise
server
Here is my procedure for a stand-alone BOXI server to produce reports
for a production mid-tier on any platform. The BOXI server is on
Windows Server 2003 Enterprise R2.
Install IIS 6.0
Install Java SDK 1.5.0_12
Install SQL Server 2005 Std x86 and Sp1 in mixed mode for Crystal Report
Server.
SQL Server authentication and TCP/IP limited to subnet - no port open
in Firewall
Create local SQL Server account <crystal user> as a db creator
Install Crystal Reports Server XI on IIS
Use .NET 2.0 and un-check Java
Specify local SQL Server (server name instance) and crystal user
account information
CRXI installer creates BOE11 database and five CMS_xxxxxxx tables
(The Central Management Server in the Central Configuration Manager may
have to have the crystal user account pwd set manually)
Install Mid-Tier 7.0.01 (IIS service off) and force load of Tomcat
5.5.17 with web enabled (port 8080)
Make sure you select to also install the AR Crystal Web Application
Edit tomcat config to add windows service account with strong password
with Roles: manager
Start - Tomcat 5.5 - Monitor Tomcat
Right-click Open from the system tray to Configure
On the Java tab
Change "Initial memory pool" to 1024
Change "Maximum memory pool" to 1536
Change "Thread stack size" to 3000
Restart Tomcat service
Add service account to local Power Users group
Change Apache Tomcat service to run under service account
Restart Tomcat service
DO NOT Edit prefetchConfig.xml to pre-load and cache forms or
applications - this server is for Crystal Web _only_
Configure mid-tier server at http://<webserver <http://%3cwebserver>
fqdn>:8080/config/
General Settings
Set values for Preference, Data Visualization Module, Homepage, and
Authentication Server to <ar server fqdn>
AR Server Settings
Installation should add one server, <ar server fqdn>- Port #####
If used to serve CRXI for other remedy servers, they will need to be
listed (test for conflicts)
Cache Settings
Default values - do not implement Pre-Fetch
Report Settings [POINT TO IIS, NOT TOMCAT]
Crystal/BO Report Engine Deployment: BOXI/Crystal Report Server 11 on
this machine
(If not listed as a choice to select, may have to uninstall/reinstall
mid-tier and force it to load the AR Crystal Web Application)
Reporting Working Directory: C:\AR System\Mid-Tier\reports
Crystal Enterprise 10 Location: http://<webserver>:80
<http://%3cwebserver%3e:80>
BOXI/Crystal Report Server 11 Location: http://<webserver>:80
<http://%3cwebserver%3e:80>
CMS Machine Name: <webserver short name> Business Objects Enterprise
XI selected (Crystal Report Server XI selection does NOT authenticate
properly)
AR System ODBC Data Source Name: AR System ODBC Data Source
CMS Folder Name: ARReports
CMS User Name: Administrator
CMS Password: <blank>
Configure production mid-tier server(s) to use the BOXI server for web
reporting
Report Settings [POINT TO MID-TIER ON TOMCAT]
BOXI/Crystal Report Server 11 on a different machine with Midtier
(If not listed as a choice to select, may have to uninstall/reinstall
mid-tier)
C:\Program Files (x86)\AR System\Mid-Tier\reports
http://<webserver <http://%3cwebserver> midtier with boxi>:8080
http://<webserver <http://%3cwebserver> midtier with boxi>:8080
Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/
________________________________
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
