IMan Database Setup

Create the IMan database. It stores the configuration settings for all integrations.

1. Open SQL Management Studio.
2. To create a database in SQL Server:
   1. Right-click Databases and select New Database.
   2. Name it IMan.
3. Create an SQL user:
   1. Right-click Security and select New > Login.
   2. Set a password and untick Enforce password policy.
   3. Click OK to close.

Windows authentication works, but takes more setting up

IMan supports Windows authentication, but it is harder to set up.

1. Assign the IMan user db_owner rights to the IMan database:
   1. Open the new user.
   2. In SQL Server 2012, open Membership in the left-hand panel.
   3. Tick the db_owner check box.

1. Open the IMan Admin Console:

   • From the Windows Start menu, click Realisable IMan > Admin Console, and approve the Windows prompt.

2. Under Database Settings, set these fields to match the database you created in step 2:

   1. Server\Instance
   2. Database
   3. Authentication: SQL Server, for the SQL user you created.
   4. Username
   5. Password

1. Press Test to check the connection. A message box shows the result:

1. If the test succeeded, DB Created shows Not Created. Press Create to create the database.
2. The Admin Console shows the recovery code for IMan's stored passwords and keys:
   1. Press Copy, or write the code down, and keep it somewhere safe, away from the server.
   2. Tick I have recorded this code in a safe place and press OK.

You need the recovery code to move or restore IMan

IMan shows the code only once. Without it, IMan cannot read its stored passwords on another server. See Secrets.

1. Press Yes to create the sample integration jobs.

1. The Admin Console confirms that it has initialised the database's secrets, then restarts the IMan services.

The rest of this guide assumes the sample jobs exist

The rest of this guide assumes you created the sample jobs.