Crystal Reports Installation

I'm attempting to create a RemoteApp for Crystal Reports and am having problems installing the software. When I try to connect Crystal Reports to an existing MySQL database that is located on a remote server, I get the error:

"BusinessObjects Enterprise CMS: Unable to connect to the CMS system database "database:208.xx.xx.xx:3307". Reason: Lost connection to MySQL server at 'reading initial communication packet', system error: 0"

What does this mean? Is the software connecting to the database at all? I can ping the IP address of the database, but anything further than that is a bust. Please advise.

TIA
blknyellaAsked:
Who is Participating?
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Ok - this is starting to make a little more sense:

1)  Crystal Reports Server is an application server through which you serve up Crystal Reports, various documents (.pdf, .xls, etc..) and control access to said content.  It's a standalone server install that comes with it's own database.  Typically, you install the application server, web server (IIS, which needs to be pre-installed and configured, Tomcat--which is installed by CRS--or both) and database (a MySQL DB ) all on the same machine.  Please note, the CMS database is not your reporting database.  I very highly recommend doing a a vanilla install on a clean Windows machine.  Take almost all of the default options, including ports.  You can do things like move the CMS database to a different server later...  The primary goal is simply to get the implementation up and running.

2)  You'll need to publish reports into Crystal Reports Server.  There are a number of ways to do this.  The report should be written in Crystal Reports 2008.  If you installed Crystal Reports Server 2008 V1 SP3 then you should be using Crystal Reports 2008 V1 SP3

3)  You'll need to configure ODBC (or other) database connections on the server in exactly the same manner they are configured on the report development machines.  You also need to configure printer drivers on the server.

4)  Assuming everything installed and was configured properly, you should be able to login to Infoview (the BI portal) with the Administrator user (no password, unless you configured one during install) and run both the sample reports and any reports you've uploaded. Infoview is accessed via URL.

5)  If your HQ is on the same network you should be able to access Infoview from your browser window (you many need a fully qualified domain name for the server as opposed to a short DNS name). If it's not on the same network, you'll need some sort of remote access enabled.

Is there a specific reason you want to use TS RemoteApp?  You're not actually going to run an "app" through it.  You're just going to access a web page.

~Kurt
0
 
mlmccCommented:
What tool are you using?

CMS is not part of Crystal Reports?

When do you get the error?
When you create the connection?

mlmcc
0
 
blknyellaAuthor Commented:
What do you mean by tool?

CMS is a component of Crystal Reports. Its included in the installation of the software.

I get the error during the setup of the software, when I'm attempting to create a connection to the database.
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
CMS is not a component of Crystal Reports.  It's a component of the BI platform, which includes Crystal Reports Server, BusinessObjects Edge Series and BusinessObjects Enterprise. Not only is it a component, but the CMS (Central Management Server) is the "brains" of your enterprise installation.

What is it you're really trying to do?

~Kurt
0
 
blknyellaAuthor Commented:
We currently have a billing system that utilizes a MySQL database. Our goal is to use Crystal Reports 2010 to access this database and create custom reports. The crystal reports software will be located on one server, and the database on another. Then, the crystal reports client will be accessed through Windows Server 2008 RemoteApp Web Access at our HQ's, which is located across town. I hope this paints a clear picture.
0
 
mlmccCommented:
The only version of Crystal that is called CR2010 is for use within Visual Studio 2010 only.  It is not a stand-alone product.

Where does CMS come into it?
I ask because you are getting an error that refers to CMS and Business Objects.

mlmcc
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Agree. If you're getting a CMS error, it's because you're trying to use or install Crystal Reports Server or one of the other BI applicaitons, not simply  Crystal Reports.

~Kurt
0
 
blknyellaAuthor Commented:
Sorry, that was Crystal Reports Server 2008.

I'm not positive where the CMS comes into play. During setup Crystal Reports asks to specify the prots numbers for the Crystal Reports 2008 V1 Administrator. That is the only instance where CMS is referred to before attempting to create a connection to the MySQL database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.