KNOWLEDGE BASE

Error "Windows authentication failed. Possible network configuration issue. Please contact your system administrator." Connecting to MS SQL Server Parallel Data Warehouse


Published: 14 Feb 2018
Last Modified Date: 31 Jan 2019

Issue

When connecting to a Microsoft SQL Server Parallel Data Warehouse, the following error might occur:
Windows authentication failed. Possible network configuration issue. Please contact your system administrator.

Environment

  • Tableau Desktop
  • ODBC 13 driver for SQL Server
  • MS SQL Server Parallel Data Warehouse

Resolution

Check to see if Tableau Desktop is using the "ODBC Driver 13 for SQL Server" when connecting to the MS SQL Server PDW data source, via the following steps:
 
Attempt to reproduce the issue and create clean log files. For more information, see Sending Tableau Desktop Log Files.
In the new clean log files, search the tabprotosrv.txt file for the following text:

DRIVER=ODBC Driver 13 for SQL Server

This text in the tabprotosrv.txt file indicates that Tableau Desktop is attempting to use this driver to connect to the data source. 

Option 1:

Uninstall ODBC Driver 13 for SQL Server via Settings > Apps or Programs & Features.

Option 2: 

If you are unable to uninstall the driver, you can try a .tdc file similar to the below to force Tableau Desktop to use the native driver:
<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='sqlserver' enabled='true' version='10.0'>
<vendor name='sqlserver'/>
<driver name='sqlserver'/>
<customizations>
<customization name='odbc-connect-string-extras' value='DRIVER={SQL Server Native Client 11.0}' />
</customizations>
</connection-customization>


Important: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files.
Note: The  above .tdc will force all connections via the SQL Server connector to use the SQL Server Native Client 11.0 driver. 

Cause

The ODBC Driver 13 for SQL Server is not compatible with Tableau Desktop's SQL Server connector.
Did this article resolve the issue?