I need to create a solution for a mutl instance (needed by 3rd party app) 2012 failover solution. I will have 2 physical high end servers (128 gig of RAM), plenty of CPU power. It will be implemented on Standard edition (could possibly change that) 1st thought was an simple active passive cluster (I am assuming you can do this with the multiple instances?). ANy other ideas on a novel approach?
Multi-instance cluster works fine AFAIK. You may also want to look at database mirroring, which can be better than clustering in some ways. I note that on Std Ed you can only do synchronous mirroring, but with fast hardware and network it scales pretty well.
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail