If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

SQL 2008 DB Mirroring / Report Net

Started by wfadel, 14 Jul 2010 04:47:55 PM

Previous topic - Next topic

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.