KNOWLEDGE BASE

Error "Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" when connecting to Microsoft SQL Server


Published: 23 Jan 2017
Last Modified Date: 22 Feb 2017

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

Cause

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