KNOWLEDGE BASE

Error "Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" When Connecting to Microsoft SQL Server


Published: 23 Jan 2017
Last Modified Date: 18 Dec 2018

Issue

When attempting to connect to Microsoft SQL Server, the following error occurs:
 
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Environment

  • Tableau Desktop
  • Microsoft SQL Server

Resolution

Option 1: 

Download and reinstall the appropriate Microsoft SQL Server driver from Driver Download

Option 2:

Uninstall and Reinstall Tableau Desktop.

Option 3:

Upgrade to Tableau Desktop 10.5.10.

Cause

The database driver did not install correctly.
Did this article resolve the issue?