Adding a Web Part to the control panel

To add the first Web Part to the Unify control panel, you need to perform the following steps:

  1. Create the Web Part database from any one CP server

  2. Provide administrative permissions to the SDPClientAcct user from the SQL server

  3. Register the first Web Part with Unify on all CP servers

To add new Web parts or configure the default settings of the existing Web Parts, see the Adding new or configuring existing Web Parts section.

Creating the Web Part database

Perform the following instructions to create the Web Part database.

  1. Log in to the CP server as the domain administrator.

  2. Open a command window and change to the <system_drive>\WINDOWS\Microsoft.NET\Framework\v2.0.50727 directory.

  3. Run the following command:

  4. aspnet_regsql.exe -S <sql_server_ip> -E -d <database_name> -A all

    where:

The Web Part database is created.

Providing administrative permissions to the SDPClientAcct user

After creating the Web Part database, you need to provide administrative permissions to the SDPClientAcct user to access this database.

  1. Log in to the MS SQL server, whose IP address you have specified in the previous procedure, as the domain administrator.

  2. Provide administrative permissions to the SDPClientAcct user:

For Microsoft SQL Server 2000:

  1. Open the SQL Server Enterprise Manager.

  2. Expand Microsoft SQL Servers > SQL Server Group > local > Security, then click Logins.

  3. In the right pane, right-click and click New Login.

  4. Type <domain_name>\SDPClientAcct in the Name text box, then click the Database Access tab.

  5. Select the <database_name> database from the list, then select the following permissions:

  6. Click OK, then close the SQL Server Enterprise Manager.

For Microsoft SQL Server 2005:

  1. Open the Microsoft SQL Server Management Studio.

  2. Expand <server_name> > Security, then click Logins.

  3. In the right pane, right-click and click New Login.

  4. Type <domain_name>\SDPClientAcct in the Name text box, then click User Mapping in the left pane.

  5. Select the <database_name> database from the list, then select the following permissions:

  6. Click OK, then close the Microsoft SQL Server Management Studio.

The SDPClientAcct user has administrative permissions to access the <database_name> database.

Registering the first Web Part with Unify

To register the first Web Part with Unify, you need to perform the following instructions on all CP servers.

  1. Log in to the CP server as the domain administrator.

  2. Update the SQLConnection.xml file:

    1. Browse to the <system_drive>\Program Files\Ensim\Ensim Unify\cp directory and edit the SQLConnection.xml file located in this directory.

    2. Replace [DB_Server] and [DB_Name] in the SQLConnection.xml file with the MS SQL server’s IP address and the database name that you have specified in step 3, while creating the Web Part database.

    3. Save and close the SQLConnection.xml file.

  3. Create a config.xml file that contains the configuration of all the Web Parts, and save it to any local directory on the CP server.

  4. A sample config.xml file included with Ensim Unify is located in <system_drive>\Program Files\Ensim\Ensim Unify\webparts\WebPartConfiguration directory.

  5. Update the ConfigFilePath registry key with the location of the config.xml file:

    1. Open the Registry Editor using the command regedit.

    2. Expand HKEY_LOCAL_MACHINE > SOFTWARE > Ensim, then click Ensim Unify.

    3. Double-click ConfigFilePath, specify the location of the config.xml file in the Value data text box. For example, specify C:\Program Files\Ensim\Ensim Unify\webparts\WebPartConfiguration in the case of the sample Web Part.

    4. Click OK, then close the Registry Editor.

  6. Copy the assembly (.dll) files for the Web Part to the <system_drive>\Program Files\Ensim\Ensim Unify\cp\bin directory.

  7. In the case of the sample Web Part, copy the Ensim.SampleCustomWebPart.dll file from the <system_drive>\Program Files\Ensim\Ensim Unify\webparts\WebPartConfiguration directory to the <system_drive>\Program Files\Ensim\Ensim Unify\cp\bin directory.

  8. Verify that the Web Part is visible in the Unify control panels by logging in automatically to an organization or a user control panel.

  9. If you have more than one CP server, repeat the previous steps on each CP server.

  10. Ensure that the same config.xml file is copied to all the CP servers.

The Web Part is added to the Unify control panel. To personalize the Web Part settings for yourself in the control panels, see the Personalizing the Web Parts topic.

Adding new or configuring existing Web Parts

You can either download ASP.NET 2.0-based Web parts from the Internet or create your own Web parts and plug them into the control panel. To add new Web Parts or edit the existing Web Parts, you need to perform the following instructions on all CP servers.

  1. Log in to the CP server as the domain administrator.

  2. Edit the config.xml that you have created in step 3 in the previous section and add the new Web Part's configuration in it. You can also configure the default settings of the existing Web Parts.

  3. Save and close the config.xml file.

  4. Copy the assembly (.dll) files for the new Web Part to the <system_drive>\Program Files\Ensim\Ensim Unify\cp\bin directory.

  5. Run the command iisreset.

  6. Verify that the new Web Part or the updated Web Part settings are visible in the Unify control panels by logging in automatically to an organization or a user control panel.

  7. After updating the configuration for the Web Parts either in the config.xml or SQLConnection.xml files, it is recommended that you clean up and reset the personalization settings for all users by running the following commands using the SQL Query Analyzer.

    use "
    <database_name>"
    delete from aspnet_PersonalizationPerUser
    delete from aspnet_Users
    go

  8. If you have more than one CP server, repeat the previous steps on each CP server.

  9. Ensure that the same config.xml file is copied to all the CP servers.

The new Web part is added to the Unify control panels.