2428971 - BI4.x: Connectability with SQL Server 2012 'Always On' availability | SAP Knowledge Base Article

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-CS , Connection Server , BI-BIP-IDT , Information design tool , BI-BIP-UDT , Universe Design Tool , How To

About this page

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

Search for additional results

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