...
- Check which SQL user CXO uses, you can find the correct username when you start the CXO configurator:
- Stop all services through the CXO configurator Maintenance tab and close the CXO configurator:
- Move/copy the databases to the new SQL server and make sure the CXO SQL user has access to the same databases with db_owner access
- If you copied the databases you can start the CXO configurator and change the master database connection by entering the new SQL connection details:
- If the "old" SQL environment/databases is not available anymore the configurator will ask for the CXO_master details and you can enter the new SQL connection details in the same screen.
- Now click on the "Upgrade config files", this will make sure the new master connection is updated in all the CXO configuration files.
- Go to applications and change the repository database connection to match the new SQL environment, click OK and Save.
- This step is Connecting CXO-Cockpit to databases on another SQL server is now finished
- The following steps are only needed if you have extract HFM data into CXO
- Start the CXO design studio and go to the maintain system settings
- Make sure the new Microsoft Analysis Server name is correct and click save and click "Create New"
- Click "Create OLAP database" and click "OK". Do note, that depending on how big your fact database is this can take anywhere from 5 minutes to 1 hour.
- After it's finished this message will appear
- Connecting CXO-Cockpit to databases on another SQL server together with the SQL CXO SSAS cube is now finished