Symptoms

Questions concerning the SQL User Manager configuration.

i) What tables are actually used for the SQL User Manager to store users and groups?
ii) Is it possible to keep default K2 security label (which is AD) as our default and still also use users in the new K2SQL security label?
iii) The SQL script (K2 SQL User Manager (Setup).sql) is default to server name instance, how does this work if the SQL server instance contains port number.

 

Diagnoses

N/A
 

Resolution

i) In an environment with single K2 database, the CustomUM.User table is used to store all the users. This means that all SQLUM users need to created manually using the CustomUM.CreateUser Stored Procedure from K2 database, else the users will not be authenticated against the K2 Server. The reason is that the Stored Procedure encrypts the user’s password using the SCSSO key, so the K2 Server can authenticate with SQLUM.
http://help.k2.com/onlinehelp/k2blackpearl/icg/current/webframe.html_Creating_a_user.html
ii) K2Workspace can be configured to run in mixed mode (Active Directory and other user managers such as K2SQL), this will require some additional changes to the Workspace’s web.config file.
http://help.k2.com/onlinehelp/k2blackpearl/icg/current/webframe.html_Configure_K2_Workspace.html
iii) The script is specific to the K2 database instance and must be ran against K2 database (See step 2 of configure the K2 Security Provider section).
Format: SQL Service Instance, K2 Database
Example: DLX, K2
Note: If you have an instance the format should display as:
Format: SQL ServerInstance:Port_number, Database
http://help.k2.com/onlinehelp/k2smartforms/ICG/current/default.htm_Configure_SmartForms_for_SQLUM/K2_Multi-Auth_-_Configure_SmartForms_for_SQL_Server_User_Manger__SQLUM_.htm?TocPath=Considerations%20and%20Pre-install%20Planning|Authentication|Introduction%20to%20Multi-Auth|_____3