Using the database servers for mrUserData and mrInterviewData
To access mrUserData and mrInterviewData by using a database server configuration, complete the following steps:
1 Backup the mrUserData and mrInterviewData databases, and then restore them to the target SQL Server. Use the same database names.
2 Update the following registry keys that are under:
HKEY_LOCAL_MACHINE\SOFTWARE\SPSS\MRUserManagement\Database\
and
HKEY_LOCAL_MACHINE\SOFTWARE\SPSS\MRPropertyManagement\2.0\Site
▪CustomerAccount
▪Roles
▪UserRoles
▪Users
▪UserTickets
The registry requires information from your ConnectionString or connection properties.
Change the values as follows:
▪AUTH_INTEGRATED, as defined in your connection information
▪INIT_DATASOURCE, as defined in your connection information
Add the following keys:
▪AUTH_USERID, as defined in your connection information
▪AUTH_PASSWORD, as defined in your connection information
3 In DPM Explorer, change the following properties under Site\Properties. Specify the database server name in < > (angle brackets) (see
Referring to database servers).
▪CATISessionDataBaseServer
▪SessionDataBaseServer
4 Use SQL Server to detach the mrUserData and mrInterviewData databases, to make sure that they are not used.
5 Restart the mrDPMServer and mrUserAdminServer service, and then restart the Microsoft IIS service.
Adding servers to the cluster
If you add a server to the cluster, the server attaches itself to the original databases. To correct this, complete the following steps:
1 After installation, change the registry settings as in step
2.
2 In DPM Explorer, change the DefaultCluster property to add the server to the cluster.
See