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

Installing Crystal Report Server 2008 Trial

Hi,

I am having trouble installing Crystal Report Server 2008 on a standard Windows 2008 32 bit box.

I have tried installing with the new MySQL DB option, but I get CMS errors during installation and when installation is complete CMC won't start. Also, I cannot connect to the MYSQL DB using the credientiasl given at installation.

Now I am trying to install it and point it to an empty (fake) 'CMS' MS SQL Server 2008 Database, but the installation wizard gives me an error 'Invalid Parameters' after specifying the CORRECT ODBC Datasource, DB user and password. I verified the ODBC connection countless times.

What a nightmare. I need to install this for evaluation. Can anyone help?

TIA
0
mullykid
Asked:
mullykid
  • 6
  • 4
1 Solution
 
mlmccCommented:
What errors do you get during the install?

mlmcc
0
 
mullykidAuthor Commented:
Hi,

As mentioned above, if I install using MySQL it appears I can't connect to the DB (after it is installed). CMC does not launch.

When installing using MS SQL Server (as an existing DB) during the wizard, it can't validate the DSN and DB parameters specified, even though they are correct.
0
 
Kurt ReinhardtCommented:
I have tried installing with the new MySQL DB option, but I get CMS errors during installation and when installation is complete CMC won't start. Also, I cannot connect to the MYSQL DB using the credientiasl given at installation.

mlmcc is asking for the exact error message you receive - that's important for troubleshooting.  Simply stating "I get errors" isn't enough to help.

That being said, if I had to guess (having installed Crystal Reports Server, BusinessObjects Edge and BusinessObjects Enterprise countless times), I'd say there's a good chance your errors pertain to either not having the correct Windows permissions during installation or other general Windows issues on the server.  Time and again I've seen issues crop up for both.

1)  If you're installing to a Windows 7/Windows Server 2008 machine you must right click the setup.exe and select "Run as Administrator".  It doesn't matter if you're logged in as Administrator.   Frankly, I do this with all software I install on those OSs, although this requirement is sporadic with different packages.  With Crystal Reports Server, however, your install will most likely fail if you don't do it.

2)  Make sure MySQL isn't already installed

3)  Make sure you have the appropriate server roles created for Crystal Reports Server, which include at least Application Server.  If you intend to  use IIS, you need to make sure .NET Framework, IIS and some additional features are installed.

4)  You should generally have a good, clean Windows install.  Crystal Reports Server is not really designed to share a machine with other application server software.

If you've got a good, clean Windows build with prerequisites established and install the application as an Administrator using the method above, you should be good to go.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mullykidAuthor Commented:
Thanks rhinok. I will implement your tips and get back to you. :)
0
 
mullykidAuthor Commented:
Hey,

Still won't install using the tips above. Perhaps I don't have the proper server roles? Either way, I can't believe how hard a task this is. This installation really does make an idiot out of you!! :)

If there are no other suggestions, I will award the points & close the thread.

Thanks for all your help.
0
 
mullykidAuthor Commented:
Sorry, I should have mentioned that none of the crystal services are created. Only 2 services, including the the tomcat service are created. I get a CMC connection error during installation with an option to proceed or cancel.
0
 
Kurt ReinhardtCommented:
At this point, there's a possibility you have some corruption due to multiple install attempts.  Do you have Crystal Reports installed on this same machine?  What other software do you have installed?  Do you have the web server and application roles set up?

Basically, the install goes like this:

1)  Clean windows build - log on as a user with Administrative privileges
2)  Set up the application and web server roles
3)  Install Crystal Reports 2008 by right-clicking the setup.exe and choosing "Run as Administrator" (it has to be installed first if it's going to be on the same machine and it's recommended to have it for troubleshooting purposes)
4) Install Crystal Reports Server by right-clicking the setup.exe and choosing "Run as Administrator" - choose all the default settings, don't bother entering an Enterprise administrator password yet, make your root and SA mysql passwords something easy to remember (and write them down somewhere).  Choose both IIS (which is installed with the web server role) and Tomcat - this way if one doesn't work, but the other does it will help troubleshooting.

If services aren't being created, there's a chance you still don't have the appropriate level of permissions.
0
 
mullykidAuthor Commented:
Thanks rhinok for everything.
0
 
Kurt ReinhardtCommented:
You've got it up and running?
0
 
mullykidAuthor Commented:
Yes!! Got it running last night. The only thing I did different was not enter an Admin password. I set to configure it later as u said! Weird!
 Thanks again!!! :)
0
 
Kurt ReinhardtCommented:
Glad I could help!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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