I'd like to install multiple application into single server but some of the applications has its own SQL Server database requirement.
So like the following:
App1 - SERVER-VM\SQLDB1
App2 - SERVER-VM\SQLDB2
Appn - SERVER-VM\SQLDBn
assuming those application can use SQL Server 2012 Express Edition, can I just install SQL Express Edition and then set multiple DB instances for all of those apps above ?
Or is it better just to deploy it using single SQLDB Instance and then just install multiple DB under the default SQLEXPRESS instance ?