Question How do you clean up the environment after a failed Workflow install or the existing installation becomes corrupted?
Answer The following steps describe how to clean install Workflow:
On the Workflow server, if you have any customized projects, backup the WorkflowProjects folder, located at <Workflow_installation_drive>:\Program Files\Altiris\Workflow Designer\WorkflowProjects, to a folder outside of the Workflow Designer folder.
In Windows Add or Remove Programs, uninstall (if found):
Altiris Workflow Designer. Note: The clean install may just be tried by uninstalling just Altiris Workflow Designer and skipping the others from step 2. If this clean install doesn't work, then next ensure that all Workflow-related software is removed from Add or Remove Programs.
Altiris Process Manager.
Altiris Office Workflow Integration.
Altiris Outlook Integration.
Altiris Workflow Task Tool.
Ensemble Document Shell Integration.
In Windows, delete the <Workflow_installation_drive>:\Program Files\Altiris\Workflow Designer folder.
In Windows Services, ensure that LogicBase 2006 Server Extensions has been removed. If not, manually remove the service. This can be done in several ways such as removing the registry key for it under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, or, from a command prompt by typing SC DELETE <service_name>.
Reboot the Workflow server.
Note: The next set of steps may be skipped regarding removing the Ensemble database in SQL (steps 7 through 10). If the clean install does work, then next continue at step 8.
On the SQL Server, open SQL Server Management Studio and login as a SQL administrator.
Delete the Ensemble database by going to <server_name> > Databases > Ensemble, right clicking on Ensemble, and choosing Delete.
From the Delete Object window, click on Close existing connections to enable that, and then click on the OK button. Note: Alternatively, you can backup the Ensemble database before removing it, or skip these steps. For a failed install, especially on a test or new production server, however, it is recommended to completely delete the Ensemble database to ensure that the next install succeeds.
Search the SQL Server using the Start > Search function for "Ensemble*.*". If any matches are found, evaluate these to determine if they were part of the Ensemble database. There may be left over .mdf files or logs; if so, delete these.