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: 20 Aug 2020

Issue

When you try to connect to Microsoft SQL Server after Microsoft ODBC Driver for SQL Server 17.2.0.1 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
  • Windows
  • MS SQL Server
  • Microsoft ODBC Driver for SQL Server 17.2.0.1 (it might occur with 17.3.x, 17.4.x)

Resolution

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

Cause

Microsoft ODBC Driver for SQL Server 17.2.0.1 is not compatible with Tableau. The ODBC driver for SQL Server included in the installer of Tableau Desktop is tested and compatible. 
 
Did this article resolve the issue?