Forum Stats

  • 3,769,708 Users
  • 2,253,013 Discussions


Hyperion Essbase configuration issue on DR server

Hyperion_Harry Member Posts: 11 Red Ribbon
edited Dec 19, 2019 4:34AM in EPM System Infrastructure

Hi Guys,

We are setting up DR for our client. and planning to use DNS alias to switch between prod & DR.

Prod installation & config is completed, Issue is that when configuring Hyperion on Prod servers, they had given DNS alias of SQL server, instead of host name, when setting up shared services.

Now when we try to install & Configure DR servers we cannot give DNS alias, because it will point to Prod SQL server and may mess up shared services setup in prod.

I can use the DR SQL server hostname for configuring Shared services on DR server, but SQL servers are replicated every day/every week from Prod to DR, so all the config details will be overwritten, bringing in SQL DNS alias.

What can be done to avoid this?