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:
Create the Web Part database from any one CP server
Provide administrative permissions to the SDPClientAcct user from the SQL server
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.
Perform the following instructions to create the Web Part database.
The Web Part database needs to be created only once when the first Web Part is added.
Log in to the CP server as the domain administrator.
If you have multiple CP servers, you need to perform the following instructions on any one CP server.
Open a command window and change to the <system_drive>\WINDOWS\Microsoft.NET\Framework\v2.0.50727 directory.
Run the following command:
aspnet_regsql.exe -S <sql_server_ip> -E -d <database_name> -A all
where:
<sql_server_ip> is the MS SQL server’s IP address, where the Web Part database will be created. You can also specify the Fully Qualified Domain Name (FQDN) or NETBIOS name of the SQL server instead of its IP address.
<database_name> is the name of the database that will contain the personalization settings of all the Web Parts for each Unify user.
The Web Part database is created.
After creating the Web Part database, you need to provide administrative permissions to the SDPClientAcct user to access this database.
You need to perform the following instructions only once when the first Web Part is added.
Log in to the MS SQL server, whose IP address you have specified in the previous procedure, as the domain administrator.
Provide administrative permissions to the SDPClientAcct user:
For Microsoft SQL Server 2000:
Open the SQL Server Enterprise Manager.
Expand Microsoft SQL Servers > SQL Server Group > local > Security, then click Logins.
In the right pane, right-click and click New Login.
Type <domain_name>\SDPClientAcct in the Name text box, then click the Database Access tab.
Select the <database_name> database from the list, then select the following permissions:
public
db_owner
db_accessadmin
All permissions starting with aspnet
Click OK, then close the SQL Server Enterprise Manager.
For Microsoft SQL Server 2005:
Open the Microsoft SQL Server Management Studio.
Expand <server_name> > Security, then click Logins.
Type <domain_name>\SDPClientAcct in the Name text box, then click User Mapping in the left pane.
Click OK, then close the Microsoft SQL Server Management Studio.
The SDPClientAcct user has administrative permissions to access the <database_name> database.
To register the first Web Part with Unify, you need to perform the following instructions on all CP servers.
Update the SQLConnection.xml file:
Browse to the <system_drive>\Program Files\Ensim\Ensim Unify\cp directory and edit the SQLConnection.xml file located in this directory.
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.
Save and close the SQLConnection.xml file.
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.
A sample config.xml file included with Ensim Unify is located in <system_drive>\Program Files\Ensim\Ensim Unify\webparts\WebPartConfiguration directory.
Update the ConfigFilePath registry key with the location of the config.xml file:
Open the Registry Editor using the command regedit.
Expand HKEY_LOCAL_MACHINE > SOFTWARE > Ensim, then click Ensim Unify.
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.
Click OK, then close the Registry Editor.
Copy the assembly (.dll) files for the Web Part to the <system_drive>\Program Files\Ensim\Ensim Unify\cp\bin directory.
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.
Verify that the Web Part is visible in the Unify control panels by logging in automatically to an organization or a user control panel.
If you have more than one CP server, repeat the previous steps on each CP server.
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.
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.
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.
If you want to reuse the sample Web Part that displays certain custom hyperlinks, you can update those hyperlinks in the Links.xml file located in the <system_drive>\Program Files\Ensim\Ensim Unify\webparts\WebPartConfiguration directory. Ensure that you save the file in the same location after updating the hyperlinks.
Save and close the config.xml file.
Copy the assembly (.dll) files for the new Web Part to the <system_drive>\Program Files\Ensim\Ensim Unify\cp\bin directory.
Run the command iisreset.
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.
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
The new Web part is added to the Unify control panels.