Loading

MS SQL Server Error 2F0F5E42 Cannot resolve the collation conflict between "Japanese_CI_AS" and "Japanese_CI_AI" in the equal to operation Upon Creating Extract

Publiseringsdato: Feb 23, 2026
Beskrivelse
When creating an extract using a join clause, the following error could occur with a MS SQL Server connection:

Error 2F0F5E42
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Cannot resolve the collation conflict between "Japanese_CI_AS" and "Japanese_CI_AI" in the equal to operation.

Cause

Collation mismatch when Tableau Desktop attempts to create a temp table.
Løsning
Create the following Tableau Datasource Customization (TDC) file for MS SQL Server.  Please see the Tableau Online Help for further information on creating the TDC file. 

In an XML editor such as Notepad or Sublime, create the TDC file with the following content and place the file in the My Documents\My Tableau Repository\Datasources folder path:

<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='sqlserver' enabled='true' version='19.1'>
<vendor name='sqlserver'/>
<driver name='sqlserver'/>
<customizations>
<customization name='CAP_CREATE_TEMP_TABLES' value='no' />
</customizations>
</connection-customization>

 
Knowledge-artikkelnummer

001498076

 
Laster
Salesforce Help | Article