Centralizing the user and activity databases configuration utility
You can use the Centralize User Database utility to centralize multiple user and activity databases in a clustered environment. The utility must be run on all UNICOM Intelligence servers.
The Centralize User Database utility is in the following folder:
[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\Interviewer Server Administration\
Administrators should typically run the utility as they must have authority to access the Source and Target user databases and grant access to the service and anonymous users.
1 Ensure that the source database and target user database use the same password encryption. You can check the encryption algorithm in DPM Explorer or via the Windows registry. In DPM Explorer, the property EncryptionAlgorithm is the user password encryption algorithm: 1 represents MD5 encryption; 2 represents SHA-2 encryption.
2 Start CentralizedUserDB.exe, and then click Browse for a list of all accessible SQL Server instances. Select a target SQL instance (the target SQL instance can also be manually defined).
3 Enter mrUserData in the Database field.
4 If you want to transfer data from the source database to the target database, select Copy user role assignment.
5 After running the Centralize User Database utility, restart the Windows services mrUserAdminServer and mrDPMServer3 on each server.
Note
The CatiSupervisor, CatiInterviewerSession, and CatiInterviewSession tables are not centralized after centralizing the User database.
In Windows registry entry mrUserCrypto (at HKEY_LOCAL_MACHINE\SOFTWARE\SPSS\DimensionNet) records the user password encryption algorithm.
See also
