I have just installed CA BI 6.3 on a box; it is up and running. During the CA BI installation, three DB were created:
jasperserver, foodmart, sugacrm.
However, I have to install CA BI 6.3 on another different box because, as per the architecture, we will have a High Availability environment with two CABI servers running on this environment.
Both CA BI 6.3.0 should be pointing to Microsoft SQL cluster. On the Microsoft SQL, I can see the three DB created during the first installation.
But then, when I try to install the second time CABI (on a different box), if I point to the INDENTICAL DB that already exist on Microsoft SQL cluster, I can't proceed further with the installation. I then need to change the names of the DB... but If I do that... I will have two CA BI boxes pointing to different DBs, which is not the purpose/goal.
I have checked the CA BI section Configuring High Availability (HA , but I see nothing in relation to the above problem... maybe am I wrong with this configuration?
Find attached the design of CA BI, the current Microsoft SQL DB, and the warnings during the second installation.
Cheers and thanks a lot in advance for tips and advices,