KNOWLEDGE BASE

Error Code 37CE01A3 "[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" Using Microsoft ODBC Driver 17 for SQL Server


Published: 17 Jan 2020
Last Modified Date: 21 Apr 2020

Issue

When you try to connect to Microsoft SQL Server after Microsoft ODBC Driver for SQL Server 17.2.0.1 or later is manually installed, the following error occurs: 

An error occurred while communicating with Microsoft SQL Server 
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database. 

Error code: 37CE01A3 

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed 
Unable to connect to the Microsoft SQL Server server "<server name>". Check that the server is running and that you have access privileges to the requested database. 

Environment

  • Tableau Desktop
  • MS SQL Server
  • Microsoft ODBC Driver for SQL Server 17.2.0.1 or later.

Resolution

  1. Uninstall Tableau Desktop.
  2. Uninstall Microsoft ODBC Driver 17 for SQL Server version 17.2.0.1 or later.
  3. Re-install Tableau Desktop.

Cause

Microsoft ODBC Driver for SQL Server 17.2.0.1 or later is not compatible with Tableau.
The latest version of Tableau Desktop installer contains Microsoft ODBC Driver for SQL Server 17.1.0.1, which is compatible with Tableau.
Did this article resolve the issue?