Symptoms
How to migrate K2 database to different SQL Server? Is there any way to prevent possible problems with SCSSO Keys in the process?
Diagnoses
Whenever you migrate K2 database to another SQL server machine it is necessary to rebuild SCSSO Keys. This is a requirement from SQL Server side.
Resolution
The correct process of doing this described here:
http://community.k2.com/t5/K2-blackpearl/Database-Key-error/ta-p/90663
* Note that you have to contact K2 support to obtain password key for this script.