We are trying to clone our hyperion system from Production to Development. We are using three server VMs, all of three we want to copy in Development environment.
Our environment is as below: +(We have changed Server names and IP, because Production and Development are in same domain)+
We made 3 servers with OS win Sever 2005 SP1.
a. SQL server 2005 SP1.
b. Shared service & Reporting & Analysis.
c. HFM, EPMA & FDM.
but getting some issues in between.
*1. EPMA get configured to new(DEV.) server but EPMA service is not starting.*
In event viewer i can see following log entries:
Service cannot be started.
Hyperion.DimensionServer.ProcessManager.Interface.ProcessManagerException: Process Manager could not start because database connectivity could not be established. --->
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
I think though EPMA got successfully configured it is pointing towards old database, may be I am wrong.
What should I do to overcome this issue?
I am able to sort out this issue also,
1. I re-started configuration and this time I skipped "Configure with shared service" at the first time and configured remaining components of EPMA.
2. Started all EPMA services then I configured "Configure with shared service".
These steps helped me to sort out this issue.