PRB: Installing MDAC on Terminal Server

Article translations Article translations
Article ID: 304332 - View products that this article applies to.
This article was previously published under Q304332
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all


To install software properly on a Terminal Server computer, Terminal Server must be set in Install Mode. One way to do this is to use the Add/Remove Programs application from Control Panel to install the software.

When you install Microsoft Data Access Components (MDAC) in this manner, the setup program reports that Add/Remove Programs must be terminated before installation can continue, because files needed by MDAC could be locked by Add/Remove Programs and setup would require a restart to copy these files. However, if you terminate Add/Remove Programs, there is a risk of losing data because Terminal Server will no longer be in Install Mode.


To work around this problem, follow these steps:
  1. Set Terminal Server in Install Mode by entering the following command at a command prompt:
    change user /install
  2. Launch MDAC setup from the command prompt.
  3. After MDAC installation succeeds, you can execute the following command to return Terminal Server to the default setting:
    change user /execute


This behavior is by design.


In fact, you can ignore the instruction to terminate Add/Remove Programs; MDAC setup proceeds but will require a restart to complete the installation successfully. However, the recommended way to install the software on Terminal Server is as described in the "Resolution" section.


Article ID: 304332 - Last Review: February 27, 2014 - Revision: 2.1
  • Microsoft Data Access Components 1.5
  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
kbnosurvey kbarchive kbprb kbtermserv KB304332

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from