The_SQL_DBA (2/20/2013)
Thanks for the replies folks.@george - I am not sure if they support DNS alias, but if they do it will be awesome as Mirroring is our go to HA option.
@Lynn - The last conversation I had with the vendor of this finance software, I was told there is no support for failover partners, so they recommend clustering because it uses a single virtual cluster name. Now, the OS team is not really impressed with having forced to go to clusters (VM being not an option). So, I am out here looking for suggestions before we purchase the hardware.
Anything new in SQL 2012/Windows 2012 that may help here?
That's just it, the connection string for the SQL Native Client handles the connections to the principal and failover systems, not the application. When we did it for PeopleSoft, there were NO CHANGES to the application itself.
Check out this page: http://msdn.microsoft.com/en-us/library/ms130822(v=sql.100).aspx