Solved

Crystal Report Server XI Installation Woes.. Help Please!

Posted on 2010-08-12
6
1,870 Views
Last Modified: 2013-11-16
I have a brand new HP Proliant DL385G6.  I am running the 32-bit version of Windows and have used Smart Start to build the machine as a 32-bit box.  (Yes, I can't use 64-bit as the primary application is not yet supported on it)

This is running Windows 2003 R2 SP1.  I am trying to install Crystal Reports Server XI (Not Crystal Reports Server XI2... told by SAP support my key isn't compatible and again... can't upgrade due to non-support within ERP app.).  The problem is it installs until about 90% of the way and then I receive the following error:

Setup failed to configure the server.  Refer to the server error logs and setup error logs for more information.

I hit ok, it rolls back and throws a Fatal Error "Installation ended prematurely because of an error".

In Event Viewer, I am getting Event ID 17055 for MSSQLSERVER, 17066: SQL Server Assertion File <serverma.c>, line=2656.  Failed Assertion = '(numSMT & (numSMT - 1)) = = 0.

The next error is, Event ID 17055 for MSSQLSERVER.  17310. SqlDumpExceptionHandler:  Process 968 generated fatal exception c000001dEXCEPTION,ILLEGAL_INSTRUCTION. SQL Server is terminating the process.

I've attached the SQL installation logs below.  I am not using a full or exising version of SQL, but letting the installation use MSDE.  

Troubleshooting steps taken, Initial install was completely current including SP2 and AV (Symantec Endpoint Protection).  The installation failed then, so thought maybe a conflict with AV or SP2.  So, Brand new install from scratch at the SmartStart level, then DID NOT apply SP2 and decided to install AV after all apps are working, so that is not currently on the system.  

Crystal Reports Server is the application I started with, failed, so then I installed Supporting Apps, Acrobat, Office, HagenOA and BarTender.  Still no go.  I have installed .NET 2, 3 and 3.5, I have run all the patches, cleared the logs and registry.... zip.

NO matter what installs same place.  I have tried installing from CD and copying to local disk and installing that way.

I have to get this on this machine to replace an ancient machine that is ready to die and we rely heavily on this.  Help please!  

Thanks.
0
Comment
Question by:jnordeng
  • 4
6 Comments
 
LVL 7

Expert Comment

by:bouscal
ID: 33426672
Since it appears that the issue is an incompatibiliy with MS SQL I suggest using the out of the box MySQL that is installed with CR Server.  If that helps the installation complete you can then go to the Central Configuration Manager (CCM) and stop the Server Intelligence Agent and redirect the auditing to the MS SQL server.  Once you start the Server Intelligence Agent it will then create the necessary tables in your MS SQL database.



0
 

Author Comment

by:jnordeng
ID: 33432856
Great idea, but I'm not using SQL.  However; your thought makes sense.  So, I downloaded the MSDE for SQL 2000, as I don't think 2005 will work with this versi on of Crystal as it looks like it only supports 2000 or 7.

However; that won't install either.  I get the weirdest message.  I must have something hiding in the registry, so looking for any stored passwords.

The error for the MSDE installation is:  A strong SA password is reuired for security reasons.  Please use SAPWD switch to supply the same.  Refer to readme for more details.  Setup will now exit.

I never entered a password.  Thoughts?
0
 

Author Comment

by:jnordeng
ID: 33465918
I got past the SAPWD switch issue, helps to read the readme file. ;).  So, the installation for MSDE, downloaded from Microsoft's website started to install, and raise my hopes.  Only, to fail and bring great disappointment as it is the very same isntallation issue and errors I received when trying to run the Business Objects Crystal Server XI installation.

What on earth is preventing me from installing a MSDE instance on this box?  I really don't want ot reformat again as I've experienced this issue before.  Are there any known issues with this hardware?  I know it's not the OS, I'm running Windows 2003 R2 on several other servers, though they don't have SP2 and it's fine.

Thoughts?  This is really becomgin a critical issue!  Thanks.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:jnordeng
ID: 33738368
Is there another Business Intelligent reporting/scheduling engine that I can use in Place of Crystal Reports Server?  I've downloaded the demo for 2008, and that installs (yeah!) but whenever I try to schedule a report to run, it simply cannot open the connection.

Thoughts?  I need to get this off the ground.  Thanks.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33759364
0
 

Accepted Solution

by:
jnordeng earned 0 total points
ID: 33855030
Thanks for the help.  I ended up getting Crystal Reports Server 2008 working.  I am convinced that the problems with Crystal Reports Server XI was a conflict with the processors.

Not sure how or why, maybe with all the demos and changes, but now Crystal Reports Server 2008 is working.  I mentioned to support that there is missing documentation from the demo and you have to manually add a period and select file extension when setting up the report to run.

One thing I did was install Crystal XI as suggested on the server.  THrough that opening the report, there was something with the ODBC connection.  So, on the server itself, updated the report to the DSN which was using the same settings and ID on another box and had success.  I don't really understand why there was a problem as I was using multiple reports to test.  But it's now working and I just applying the perm key yesterday.

Thanks for all the suggesitons.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

747 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