Install could not log on to the database

[mdwyer]

I am creating a backup of our CE9 installation on a new development server. The APS will be installed on an Oracle 10g database. The install is being performed from the CD CD. (That's a joke: Crystal Decisions' original media.)

When the install asks what database to use, I indicate Oracle native driver, name the instance, and supply the schema name and password. The instance, tnsnames.ora, and schema name are validated to the proper database because the password for this schema is unique.

At the end of the install, when the APS is being started, I believe, I get the error message "Install could not log on to the database". The APS name shown is the server I am installing on, user is Administrator, password is blank, and Authentication is secEnterprise.

Why would the logon fail? It's a clean re-install so the password should default to no password. There was an APS in the db instance, but the three tables have been renamed. The previous password does not work either. I've checked that all passwords used are in lower case.

I have one other symptom: If I open the Crys. Config. Mgr. and open the Property sheet for Crystal APS, then click the Configuration tab, I get this error: "Failed to retrieve cluster name from the database. Reason: Database Access Failure.." The tab then shows APS Data Source as the correct instance, but "APS is not part of a cluster." That seems okay, because I am not clustering APS's, but if I go to the production server, the same CCM/APS config tab says "APS belongs to cluster "PRODSVR", which is the name of that server.

Install.pdf says to select No cluster if you are not using clusters, so I did not specify the DEVSVR as a cluster name. Should I have?

 

[synapsevampire]

It's saying that it can't log on to the Oracle database, not that you can't log on to CE.

-k

 

[mdwyer]

You may be right, but why would the message be on a CE logon screen (User Name, Password, and Authentication: secEnterprise, LDAP, or NT)? And then, where would the database logon credentials be changed so the installed can logon?

By the way, I went ahead and removed CE and reinstalled, specifying the "existing cluster" of the current machine. Still failed, AND the CMC/APS config still says "APS is not part of a cluster."

Does CE9 have a problem with Win2003?

 

[mdwyer]

Well, this time it worked as expected. I must have missed something in the password entries, or something flaky was floating around the network and finally got synched up. We'll have another look Monday AM. Thanks, sv.

 

[mdwyer]

Well, it happened again - but this time the problem is more obvious, so let me explain for anyone who may come across this in the future.

I was installing a dev copy of CE9 but using a previously populated APS database, where the Administrator password had been redefined. So the install, using the default null password, was unable to connect.

To get around this, I launched the CCM, stopped the APS, clicked the Specify APS Datasource icon, and selected Recreate the current Data Source. I went back to the installed and clicked the Log On button - 'voila'!

Also, this procedure also changed the "APS belongs to cluster XXX" to the correct cluster name.

It makes a lot more sense without the pressure I was working under last week.