How to Install ODBC or MDAC on Terminal Server

• Microsoft Windows NT Server version 4.0, Terminal Server Edition

SUMMARY

The installation of Microsoft Data Access Components (MDAC) presents special challenges when installing on Terminal Server. Also, as the Terminal Service Licensing service uses ODBC, an incorrect installation of MDAC will render the service inoperable.

The important point to remember here is that ODBC is used by both applications and system services, and some manual steps might have to be employed to ensure that nonpriviledged services can access the components.

MORE INFORMATION

The first set of steps are necessary to ensure the MDAC service installation will finish.

NOTE: The installer must be in the local administrators group.

1. Stop all ODBC-dependant services including, but not limited to, IIS, SQL Server, SQL Server Enterprise Manager, TS licensing service, and ODBC Administator itself, and so on.



2. Remove all users who are logged on.



3. Delete the following files:

   Ds16gt.dll
   Ds32gt.dll
   Odbc16gt.dll
   Odbc32.dll
   Odbc32gt.dll
   Odbcad32.dll
   Odbccp32.cpl
   Odbccp32.dll
   Odbccr32.dll
   Odbcint.dll
   Odbcinst.cnt
   Odbcinst.hlp




4. At a command prompt, type change user /install.



5. Now you are ready to start the installation. Download MDAC from http://www.microsoft.com/data and install it with the "complete" option.
   
   IMPORTANT: Before closing the setup screen or restarting, you must run the application compatibility script, Odbc.cmd.
   Please note there will be only three users with access to some components located in %systemroot%\system32: the installer, the adminstrator group, and system. The installer will need to manually add the generic everyone group, with read and execute rights, to some of the odbc files:
   
   Msvcrt.dll
   Msvcirt.dll
   Odbc32.dll
   Odbc32gt.dll
   Odbccp32.cpl
   Odbccp32.dll
   Odbccr32.dll
   Odbccu32.dll
   Odbcint.dll
   Odbcjet.*
   Odbcji32.dll
   Odbcjt32.dll
   Odbctl32.dll
   

Q216159 Dr Watson Starting TS License Service with Error 3221487623

Additional query words: com dcom sdk

Keywords :
Version : winnt:4.0
Platform : winnt
Issue type : kbinfo