We have latest essbase installed and configured successfully, all foundation services and essbase in one server, and database is in different server using SQL server.
Now IT wants to change database server name, which we do use it during installation and configuration. I would like to ask advice on this.
1. Is it possible to change database server name after the installation and configuration? I am thinking these may be involved bunch of search on connection string in multiple places, but not sure it is good practice here.
2. What is best option here if you have done this before.