Symptoms

After database consolidation, attempting to start the K2 service results in the following error:

2001 Error Starting Host Server: SQL User manager Error:Cannot open database 'K2SQLUM' requested by the login. The login failed.
Login failed for user ''DOMAINUSER]'.
 

Diagnoses

This error is caused by incomplete configuration on the K2SQL Security label, which prior to consolidation points to the SQLUM database.
 

Resolution

Update the AuthInit and RoleInit columns in the K2.HostServer.SecurityLabel table to point to the newly consolidated K2 database, instead of SQLUM.