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

Issue

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.

Environment

Tableau Desktop
MS SQL Server

Resolution

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>