Install TIBCO iProcess Sql Server Engine

The installation usually won’t success when you first install the iPE. If the installation failed, you can delete the installation directory; drop the swpro and swuser users and all the tables belong to them in Sql Server database. But don’t delete the swadmin and staffwar users in the OS. And then reinstall the iPE, it will success.

1. Create 3 user accounts “swpro”, “swadmin” and “swuser” (local to the computer) with password (wireformat-123). Assign local admin rights to these users.

2. 1. Then go to control panel->Administrative tools->Local Security Policy->Local policies (left pane) ->user right assignments

Here for three policies (act as part of OS, logon as a service, log on as a batch job), you have to add those three users mentioned above.

2.2. Go to ‘Component services’ in the Administrative Tools.

Component Services->Computer (left pane)->My Computer.

Right click on My Computer and go to Properties. In the COM Security tab. Click the Edit Limits button in the Access Permissions and add swpro, swadmin and swuser in the user names and check the Remote access checkbox.

Repeat the above step for the Edit Default in Access Permissions and also for Edit Limits and Edit Default in the Launch and Activation Permissions.

3. Logon as swpro (recommended) and install all the software needed for iProcess.

3.1 Install SQL server 2000 with service pack 4.

3.11. Create a new db for iProcess.

3.12. In the newly created DB create 3 logins (mentioned above) with same username and password. Find steps below.

a. Go to Securityà right click on login choose new Login.

b) Select server Roles and give all the roles

c) Select Database Access and select the database you have created and grant all roles.

Repeat these steps for all three users (swpro, swadmin, swuser)

3.2. In DB PropertiesàPermissions, check all the properties except Backup DB and Backup log

3.3 Create an ODBC (data source) for your newly created DB.

Got control panelàadministrative toolsàData Sources (ODBC) and create a new odbc in system DSN

(Select default database as the database that is created in the step 3.11 above)

4.0 Before I process server installation you need to install pthread.dll

Pthreads-w32-2.7.0.zip

4.1 Next install iProcess Engine with all options checked except “configure email plug-in" (This option can be selected if you want to configure the settings for iProcess Email plug-in)

5. Install JMS (Ignore this step if you already have the JMS installed on your system)

6.1. Open the iProcess Objects server from control panel and in memory tab; select ‘enable memory login’, select warning check box.

6.2. In disk log tab, set memory size to 100MB.

Restart your machine.

7. Type services.msc in run, check whether two staffware services are running or not.

8. Install iProcess windows client

9. Install iProcess modeler.