SQL 2008 DB Mirroring / Report Net

[wfadel]

Hello,

Is Report net capable of handling the Transparent Client Redirection provided by the SQL Native Client (SNAC) for database mirroring?

Essentially, SNAC allows for this type of connection string:
Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;

The "Failover Partner" property allows for redirection when the Principal fails over to the Mirror.

Thank you,

Will

[FM]

How is this different then an MS-Cluster?

You're configuring two identical databases anyway, no?

So you have two servers with active passive (since SQL server doesn't support active active like oracle)

and point the connection string at the cluster name.