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 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 BOXI/Crystal Report Server 11 Location: http://<webserver>: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 midtier with boxi>:8080 http://<webserver midtier with boxi>:8080
Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Tuesday, September 11, 2007 1:21 PM To: [email protected] Subject: Re: Running mid-tier reports on Business Objects Enterprise server ** I am in the process of trying to get this to work also - and still having problems. We have BO on a separate server than mid-tier - and we ran the installation for the ARWEBViewer piece but it isn't setting things up correctly. Pam Hollis Tractor Supply Company Senior Remedy Developer Remedy Skilled Professional 615-440-4617 (Office) 615-484-4617 (Fax) [EMAIL PROTECTED] _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Tuesday, September 11, 2007 12:44 PM To: [email protected] Subject: Re: Running mid-tier reports on Business Objects Enterprise server We're trying to get it to work, but BMC's documentation is terrible. As a result, we don't have it up and running yet. Part of this is my fault since I've been swamped with work and it hasn't been my top priority, but we have a Business Objects consultant that has been working on it for months and has made no progress whatsoever. Shawn Pierson -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Pospisil Sent: Tuesday, September 11, 2007 11:21 AM To: [email protected] Subject: Running mid-tier reports on Business Objects Enterprise server ** ++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please Read The Disclaimer At The Bottom Of This Email ++++++++++++++++++++++++++++++++++++++++++++++++++++++ Hello listers, I was wondering if anybody runs ITSM Crystal reports on mid-tier using Business Objects server. I am interested in any configuration/installation tips and tricks apart from those described in the documentation. Any opinion on whether to run the BO server on the same server or on a separate machine? Also, I was wondering what is the licensing approach for the BO server. Does Remedy need just a single user license on the BO server in order to run and display built in reports? Or would that be a breach of licensing rules from Business Objects licensing point of view? Thanks Jiri Pospisil Remedy Administrator IT Production LCH.Clearnet ************************************************************************ ************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify [EMAIL PROTECTED] The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com ************************************************************************ ************************* __20060125_______________________This posting was submitted with HTML in it___ Private and confidential as detailed here <http://www.sug.com/disclaimers/default.htm#Mail> . If you cannot access hyperlink, please e-mail sender. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
