SAP Knowledge Base Article - Preview

2428971 - BI4.x: Connectability with SQL Server 2012 'Always On' availability

Symptom

  • The Always On Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring introduced in SQL Server 2012 (see https://msdn.microsoft.com/en-us/library/hh510230.aspx)
  • What is connectability with SQL Server 2012 'Always On' availability in BI4.x?
  • How to add parameter 'ApplicationIntent=ReadOnly‘’ to the connection string in BI4.x in order to connect to the read only node of a SQL Server 2012 'Always On' cluster?


Read more...

Environment

  • SAP BusinessObjects BI Platform 4.x
  • SQL Server 2012

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

BI4, BI4.1, BI4.2, 4.1, 4.2, 4.x, connection, universe, SQL Server 2012, always on, always-on, cluster, clustering, ApplicationIntent, Application Intent, readonly, read only, read-only , KBA , BI-BIP-SL , Semantic Layer , BI-BIP-IDT , Information design tool , BI-BIP-UDT , Universe Design Tool , BI-BIP-CS , Connection Server , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.