It's a bit unusual case, I know. We have sql server 2016 cluster (2 nodes, windows 2012) with 2 instances running (i.e. Act/Act). Request is to add one more instance but 2014 (same edition- Ent). Why? It's for chat component that Vendor tested only for sql server 2014 (i.e. 2016 is not supported). Certainly new dedicated VM will be better but as always... money (hardware + license).
Anyhow have couple questions:
1) Can we do this, i.e. combine 2014 and 2016 instances on the same cluster?
2) should we do this, i.e. where is the catch?
Let's say cluster has enough resources to support 3 instances- what else we should keep in mind?
Thanks in advance.