Article ID: 216149 - View products that this article applies to.
This article was previously published under Q216149
The installation of Microsoft Data Access Components (MDAC) presents special challenges when installing on Terminal Server. Also, as the Terminal Service Licensing service uses Open Database Connectivity (ODBC), an incorrect installation of MDAC renders the service inoperable.
Both programs and system services use ODBC, and some manual steps may have to be used to ensure that nonprivileged services can access the components.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows
The first set of steps is necessary to ensure the MDAC service installation will finish. The last steps will ensure that MDAC will run on the terminal server and all users will be able to take advantage of the updates.
NOTE: The person performing the installation must be in the local Administrators group.
Access to some components located in Systemroot\System32 is limited to the person who performed the installation, the Administrator group, and System. The generic Everyone group needs Read and Execute rights to the following ODBC files. The current rights on these files will vary depending on the version of MDAC that is installed.
Msvcirt.dllNOTE: If you are installing MDAC 2.6 and higher, the Jet 4.0 database also needs to be installed for Terminal Server to operate properly. This is a separate installation from MDAC. This is not needed for MDAC 2.6 or earlier. You can download the Jet 4.0 Service Pack 8 Release from the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/data/aa937712.aspx#jetFor additional information about how to install MDAC on a Windows 2000 Server computer, click the following article number to view the article in the Microsoft Knowledge Base:
304332For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/304332/ )PRB: Installing MDAC on Terminal Server
286442For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/286442/EN-US/ )PRB: MDAC 2.6/2.7 Roll Back Installation/Give Error on Install
(https://support.microsoft.com/kb/216159/EN-US/ )Dr Watson Starting TS License Service with Error 3221487623
(https://support.microsoft.com/kb/232060/EN-US/ )HOWTO: MDAC Setup Troubleshooting Guide
(https://support.microsoft.com/kb/307255/EN-US/ )INFO: Component Checker: Diagnose Problems and Reconfigure MDAC
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/305838/ )PRB: MDAC Installation on Windows Terminal Server May Fail
Article ID: 216149 - Last Review: February 20, 2007 - Revision: 5.6