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

Date de publication: Feb 23, 2026
Description
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.
Résolution
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>

 
Numéro d’article de la base de connaissances

001498076

 
Chargement
Salesforce Help | Article