MOD2000: Access Workflow Designer Setup Not Complete When Reinstalling After Running Eraser (257497)



The information in this article applies to:

  • Microsoft Office 2000 Developer

This article was previously published under Q257497

SYMPTOMS

While you are reinstalling the Access Workflow Server, also known as Workflow Designer for SQL Server, you see the following message near the end of Setup:

Setup cannot continue with installation. Click OK to exit the Setup program. For help with installation requirements, see the "Installation and Setup" topic in the Administrator's Guide (modAdminGuide.chm).

When you check the SetupS.log file, you see the following entries near the end:
[Microsoft][ODBC SQL Server Driver][SQL Server]Exceptions ocurred while invoking method CreateTemplateFromFile [Microsoft][ODBC SQL Server Driver][SQL Server]Error(800a0e7a) in modTBAD.modTBAD.1: Error trying to create template from file C:\Program Files\Common Files\Microsoft Shared\Microsoft Office Developer\System\IssueTrackingENU.tpl: Provider cannot be found. It may not be properly installed.

CAUSE

One or more SQLOLEDB components that are installed by Microsoft Data Access Components (MDAC) are not installed or registered properly.

RESOLUTION

Install the Microsoft Data Access Components. You can download the newest version of MDAC from the following Microsoft Web site: To avoid other problems in the next installation attempt of the Access Workflow Designer Server, you must first perform a DROP DATABASE on the Workflow Designer database, modsystem, which was installed by the Setup that previously failed. DROP DATABASE detaches the database and deletes the files associated with it. To do this, follow one of the sets of steps below, depending on your situation.

From OSQL

Follow these steps if you have the Microsoft Data Engine (MSDE) installed without the End-User Components.
  1. Open a command prompt.
  2. Type OSQL -U sa -P.

    NOTE: This is for a server on which the System Administrator (sa) has the default blank password. If you have another account set up with administrative rights, you can use that account instead. For example, if you have a user named Bob, and he has a password of Terra1B, you would type OSQL -U Bob -P Terra1B.
  3. At the OSQL prompt, type the following:

    DROP DATABASE modsystem
    go

    The database is dropped from the server, and the modsystem.mdf is deleted.

From Query Analyzer

Follow these steps if you have installed Microsoft SQL Server or the Microsoft Data Engine End-User Components.
  1. Open SQL Server Query Analyzer.
  2. Type the following:

    DROP DATABASE modsystem

  3. Press F5.

Modification Type:MinorLast Reviewed:4/22/2003
Keywords:kbprb kbWorkFlowDesigner KB257497