KNOWLEDGE BASE

Connecting to SQL Server 2012 Replica in ReadOnly Mode


Published: 14 Nov 2013
Last Modified Date: 08 Feb 2017

Issue

Unable to connect to a SQL Server 2012 Availability Group ReadOnly replica in Tableau Desktop.

Environment

  • Tableau Desktop
  • MS SQL Server

Resolution

Create a .tdc file similar to the following:
<connection-customization class='sqlserver' enabled='true' version='9.3'> 
<vendor name='sqlserver' /> 
<driver name='sqlserver' /> 
<customizations> 
<customization name='odbc-connect-string-extras' value='ApplicationIntent=READONLY' /> 
</customizations> 
</connection-customization>

Cause

The ability to specify an Application of Intent of Read Only through the UI is not currently built into the product.
Did this article resolve the issue?