Failed To Connect To HFM Application When Using Financial Reporting Studio : "Error connecting to database connection : Server/Cluster is incorrectly configured."

Failed To Connect To HFM Application When Using Financial Reporting Studio : "Error connecting to database connection : Server/Cluster is incorrectly configured." [ID 1238573.1]
		Modified 17-OCT-2011     Type PROBLEM     Status PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

---

Applies to:

Hyperion BI+ - Version: 9.3.0.0.00 to 11.1.2.1.000 - Release: 9.3 to 11.1
Information in this document applies to any platform.

Symptoms

In Financial Reporting Studio, users are trying to run reports that use a HFM datasource are getting an error.

"Error connecting to database connection [name]: Server/Cluster is incorrectly configured.  Please reconfigure your Cluster or Server connection."

Cause

Financial Reporting Studio is not able to locate the HFM cluster.
Testing also determined that the HFM client could not connect to the HFM cluster.

The HFM cluster was not correctly configured.

Solution

Set up the HFM cluster on the FR Studio machine.

1. Go to Start > All Programs > Hyperion >Financial Management >Server and Web Configuration

2. Go to the Server/Cluster Registration tab.

3. Enter the computer name of the HFM server used to get cluster information or the name of the single server if using a non-clustered environment.  The HFM server needs to be referenced exactly as it is on the HFM server (hostname/IP/FQDN/clustername, as well as case-sensitivity for any letters).

4. Apply and OK.

5. Restart FR Studio.


Note: if HFM client is not on the FR Studio box, it will need to be installed prior to set up of the HFM cluster as listed above.