Setting up the database

For server installations only, after you've installed the Process Manager server components, you need to set up the database. Setting up the database consists of the following steps:

• Authenticating to your SQL server
• Creating a container (or database)
• Creating the tables or schema
• Establishing and testing the connection to the database
• Entering your SMTP e-mail server information and providing a system e-mail address
• Setting up connections for local and/or domain-based users and groups
• Configuring connections to LANDesk core servers (if you will be integrating with other LANDesk products)
• Saving the configuration settings and restarting Process Manager Scheduler services

The Database Utility, a tool of Process Manager, enables you to complete these tasks. Establishing the connection between the Process Manager server and database is imperative. You must be a database operator to connect to an existing database and a system administrator to create a new Process Manager database. The default database is named Workflow, however, you can name it whatever you want, and even have multiple databases. The server uses the last database it connected to as the active database.

To set up the database

1. Access the Database Utility by clicking Start | All Programs | LANDesk Process Manager | Database Utility. If you selected the Launch the Database Utility checkbox from the final installation screen, you are automatically taken to the application.
2. Insert your database system administrator credentials, server name, and name of your LPM database. You can use the default database name or rename it.
3. Click Test connection. If a database with that name exists, you'll be connected to the database. If a database with that name doesn't already exist, you will be prompted to create a new database.
4. • For an existing database, click Configure and restart services.
   • For a new database, click Yes to create it. Enter your database system administrator credentials. Make sure you have the correct SQL server name and database. Enter the name of your database. Select Create new Process Manager database and click OK. Click Execute. When the script has finished, click OK and then click Close.
4. Enter your outgoing SMTP server name. Provide an e-mail address for the system, which can be any e-mail address as long as it follows the standard syntax. Click OK.
5. If you want to turn off the ability for Approver participants in workflows to attach "conditions" to their approvals, click the Hide approve with conditions option. With this box checked, approvers will only be able to approve or deny requests.
6. Click OK to save the changes and restart the LANDesk Process Manager Scheduler services.

Your Process Manager server is now connected to the database.

If you have not yet done so, you will need to set up connections to your users and groups so they can be included as workflow participants. See "Configuring users and groups".