Categories
SQL Server

SQL Server 2000 Connection Failure

Solving the[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed Error

Share

SQL Server fails to install, and if installed, fails to display available servers.
It also fails to connect to a specific server. In all cases, it provides the error:
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Download and install a new version of Microsoft’s MDAC(Microsoft Data Access Components).
The culprit is normally a broken ODBC driver or some dll run afoul.

Share

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Share