We're in the process of installing 4 Cognos environments (Training, DEV, QA, Prod), each one on a separate VM. I'm trying to find out what the best practices are in terms of the database connection to the Content Store. Should each VM be connected to a separate database server? Or can we connect them to different databases on the same database server? We would prefer the latter but we're not sure what the implications would be. Thanks!
You can do either. If they all connect to the same database server, you will lose all your VMs if that one database server goes offline, so you might look at configuring each VM to use a standby content store on a different server in case a failover is required.
Regards,
MF.