SQL Server 2000 Connection Failure
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.
SQL Server 2000 and JDBC