SQL User Manager

The K2 SQL User Manager allows user information to be stored in an SQL database. K2 uses that SQL database for authentication and authorization of K2 tasks.
Note that the Changing the Default User Manager topics are required if you are using the newly-registered SQL user manager as the default user manager and you did not install using the SQL user manager.

In an environment with a single database, or where the 14 databases have been consolidated, the CustomUM tables take over from the K2SQLUM database mentioned here.
Scripts in these topics that reference <init>DLX,K2SQLUM</init> should be changed to <init>DLX,K2</init> ('K2' being the default consolidated database name).

Example

The following example is for the fictitious Denallix.com domain and is inserted into the SecurityLabels table of the K2HostServer legacy database. You must change the values below to match your environment. This is the same XML that is included in the downloadable script file.

Copy
<AuthInit> <init>DLX,K2SQLUM</init>** <login/> <implementation assembly="SQLUM, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d" type="SQLUM.K2UserManager"/> </AuthInit>

**The <init></init> tag has the following syntax:

Legacy Database
Format: SQL Service Instance, K2 Database
Example: <init>DLX, K2SQLUM</init>

Consolidated Database
Format: SQL Service Instance, K2 Database
Example: <init>DLX, K2</init>

Note: If you have an instance the format should display as:
Format: <init>SQL Server\Instance, Database</init>

Register the User Manager

To register the SQL user manager, one table in the Host Server database must be modified.

SecurityLabels – stores the security label, security provider and authorization/role initialization data for the user manager

The example SQL scripts allow you to setup and remove a SQL user manager. Be sure to edit the scripts to fit your configuration before executing them.

Download and extract the K2 User Managers sample scripts
Open the “K2 SQL User Manager (Setup).sql” script and edit it for your environment
Execute the “K2 SQL User Manager (Setup).sql” script from Microsoft SQL Server Management Studio against the K2 Host Server database
Refresh the User Manager Cache
Restart the K2 blackpearl Server service

Download: You can download the K2 User Managers sample scripts by clicking here.

The example scripts contain references to the DLX SQL instance and the K2HostServer database. Please edit the .sql files to replace these values before executing.