http://technet.microsoft.com/en-us/library/cc773013(WS.10).aspx

1. On this or another computer, install Microsoft SQL Server or SQL Server Express.

   Part of the ProjectWise Orchestration Framework Service installation involves connecting to a SQL Server database. You can use an existing installation of SQL Server, or you can install Microsoft SQL Server 2019 Express from the ProjectWise Server installer during ProjectWise Integration Server installation, if needed.

2. If you plan to connect to the Orchestration Framework database using an ODBC connection, then you must first create an empty database in SQL Server to be used as the Orchestration Framework database, and then create a 64-bit ODBC data source on this computer that connects to the empty database in SQL Server.

   If you plan to use a direct database connection, you can skip this step and let the Orchestration Framework Database Setup dialog (opens during Integration Server / Orchestration Framework installation) create the Orchestration Framework database in SQL Server for you.

3. Set up the user account under which ProjectWise Orchestration Framework Service will run. You will enter the credentials of this account on the Orchestration Framework Configuration page of the ProjectWise Server installer.

   This account:

   • can either be a local account or a Windows account
   • is recommended to have a password that is set to never expire
   • must be a member of the Administrators group on this computer (Control Panel > Administrative Tools > Computer Management > System Tools > Local Users and Groups > Groups)
   • must have the Log on as a service right on this computer (Control Panel > Administrative Tools > Local Security Policy > Security Settings > Local Policies > User Rights Assignments)
   • must also already exist in SQL Server (under Security > Logins)
   Tip: ProjectWise Orchestration Framework Service will stop running if and when this user account's password expires. Because Windows accounts typically have passwords that periodically expire, one solution is to use a local account with a non-expiring password. Another solution is to use a Windows domain account and set its password to never expire, or simply manually reset the password for ProjectWise Orchestration Framework Service in the Services window, ideally before the password expires.
4. Make sure the user account you use to launch the ProjectWise Server installer is a Windows account that is a member of the local Administrators group.
5. Make sure these Windows features are installed and running:
   • .NET Framework 4.7 or later
   • Message Queuing
   • Windows Search Service

   Make sure the Message Queuing and Windows Search services are running in the Services window.

6. If you plan to perform text extractions on this computer, you can either use the default index storage location as set by the ProjectWise Integration Server installer, or you can preset the index storage location before installing ProjectWise Integration Server (see Presetting the Full Text Index Storage Location).
7. Install the software required (if any) for the file types you plan to process:
   • Full text indexing

     Depending on the file types you want to index text from, you may need to install additional software on the ProjectWise Integration Server computer where the extraction is being performed. The additional software required is an IFilter for the required file type, but in some cases you may have to install the full application to get the required IFilter. The following table lists some of the common file types that you will need to install additional software for:

     To index text from	Install
     DGN and DWG documents	MicroStation (latest version is recommended)
     PDF documents	(no additional software required)
     .docx, .xlsx, .pptx, .msg (Microsoft Outlook message), .vsd documents	Microsoft Office 2010 IFilter pack with SP2 update is required. You can download this free package from Microsoft.

     Note: Currently, ProjectWise cannot index text from a DGN document that is attached to an MSG document.
   • Thumbnail image extractions:

     No additional software is required to extract thumbnail images from V8 DGN, AutoCAD DWG (AutoCAD 2010 and later formats), and Revit documents.

     Note: Thumbnails cannot be generated for PDF documents with 3D content.
   • File property extractions:

     ProjectWise Automated File Processing components support extracting file properties from the following file types:

     • Microsoft Office Open XML documents (DOCM, DOCX, DOTM, DOTX, POTM, POTX, PPAM, PPSM, PPSX, PPTM, PPTX, XLAM, XLSB, XLSM, XLSX, XLTM, XLTX)
     • Microsoft Outlook Message documents (MSG)
     • PDF documents

     • Any document that is a COM Structured Storage (https://learn.microsoft.com/en-us/windows/win32/Stg/structured-storage-start-page): DGN, DOC, PPT, XLS, MPP, VSD

     Although these were the file types tested with file properties extractions, it should be possible to extract file properties from other file types that are structured COM storages. There are no limitations for what the extensions can be for files that are structured COM storages. For example, a Microsoft Word document having the extension ABC instead of DOC will still be extracted successfully.
     Note: Due to an AutoCAD limitation, ProjectWise cannot extract file properties from DWG documents.