Simple SQL Mirror Failover Setup?

Hello,

I would think this would be very simple however I can't find a single Adobe document with any information about it!

In ColdFusion 10 under the Data Sources / SQL Server there is a Connection String box...

From my hours of Google Searching it SEEMS like all you have to do is add: AlternateServers=(X.X.X.X:1433) to that box and SQL Mirroring failover should work and be automatic...is this correct?

If anyone has any documentation or experience with this I would greatly appreciate your input...it doesn't seem like this should be all that complicated...or unique...but all the info I find on this is either really old or not really pertaining to this simple setup.

FYI SQL Servers are Microsoft SQL 2008 R2 (I think SP2).

Thanks!