Symptoms

Hi there, We did a test move of our K2Dev dbase to a different SQL server. The K2 designer is still working in that I can check something out, edit it and check it back in again. However, none of the runtime is working. If we try to run anything the error message is "Database 'CoreDev' cannot be opened because it is offline."
 

Diagnoses

The SCSSO key needs to be opened via SQL prior to running the Smartforms Configuration.

 

Resolution

Steps followed to migrate:

1. Backup dbase
2. Restore Dbase
3. Edit service instance to point to new SQL server dbase
4. Run the script below against the new dbase

Deployment Error: Please create a master key in the database or open the master key in the session before performing this operation. The key 'SCSSOKey' is not open. Please open the key before using it.

You can run the following script against the K2 database for their installation, and then repeat the configuration or the action you were doing when this error was thrown:
http://community.k2.com/t5/K2-blackpearl/SCSSO-key-error/ta-p/77244

5. Run K2 Blackpearl Setup Manager - change the sql server
6. Run the K2 Smartforms Setup Manager
7. Test K2 Designer and Runtime