Configuring Agent Information in SQL Server

The following procedure assumes that you are familiar with SQL Management Studio. In addition, you must have access permissions to modify the CCFInfrastrucure databases on the SQL server in CCFSQL.

To configure agent information in SQL Server

  1. Open SQL Management Studio, and connect to the SQL server, CCFSQL.

  2. In the CCFInfrastructure database, open the CCFUser table.

  3. Check if users such as DemoAgent1, DemoAgent2, and DemoAgent3 are already configured in the CCF User table. If not, complete steps 4 – 5 to configure DemoAgent1 and DemoAgent2. If the users are already configured, go to step 6.

  4. Configure DemoAgent1 as follows:

    1. In the AgentID column, type the next ordinal number.
    2. In the DomainUser column, type CCF\DemoAgent1.
    3. In the FirstName column, type Ann Marie.
    4. In the LastName column, type Walsh.
    5. In the Type column, type 1.
    6. In the Picture column, type DemoAgent1.jpg.
    7. Leave the Supervisor column blank so that it has a null value. (Use the Tab key to move out of the column.) This completes the DemoAgent1 user details.
  5. Configure DemoAgent2 as follows:

    1. In the AgentID column, type the next ordinal number.
    2. In the DomainUser column, type CCF\DemoAgent2.
    3. In the FirstName column, type David.
    4. In the LastName column, type Dorson.
    5. In the Type column, type 1.
    6. In the Picture column, type DemoAgent2.jpg.
    7. Leave the Supervisor column blank so that it has a null value. (Use the Tab key to move out of the column.) This completes the DemoAgent2 user details.
  6. Close the CCFUser table.