COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: wfadel on 14 Jul 2010 04:47:55 PM

Title: SQL 2008 DB Mirroring / Report Net
Post by: wfadel on 14 Jul 2010 04:47:55 PM
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

Title: Re: SQL 2008 DB Mirroring / Report Net
Post by: FM on 30 Jul 2010 03:46:31 AM
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.