Hi,

I think the underlying issue here is the link between the K2 Database Master key and the link between the SQL Service Master key has been broken, and this normally happens when moving the K2 databases, or databases in general, from one SQL instance to another.

That being said, you will NEED to run the script below to re-link the service master key with the master key.

PS - If you're running on the legacy multiple K2 databases, you will have to run the script against the following databases: K2Hostserver, K2SmartBroker, K2Smartbox, K2SQLUM

NOTE: Please make sure to take a backup of the respective K2 databases, stop the K2 Server service, run the script, and then restart the K2 Server:

GO

DROP SYMMETRIC KEY SCSSOKey

DROP CERTIFICATE SCHostServerCert

DROP MASTER KEY

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Password removed - Please Contact Support'

CREATE CERTIFICATE SCHostServerCert

WITH SUBJECT = 'Host Server Certificate', START_DATE = '01/01/2007', EXPIRY_DATE = '01/01/2017'

CREATE SYMMETRIC KEY SCSSOKey WITH ALGORITHM = TRIPLE_DES

ENCRYPTION BY CERTIFICATE SCHostServerCert

GO

Good Day  @blitzen26

An KB Article regarding this issue and the solutions to it had been created. the KB article provides a step by step guide on restoring or moving a K2 database succsessfully.

Restoring a Database:

https://help.k2.com/support-services/kbt135736?version=published

This article is based all k2 version post 4.6.9 and can also be used when experiecing errors like the below:

• The key 'SCSSOKey' is not open. Please open the key before using it.
  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.

Note: Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such using the 'Mark as Solution', 'Kudo' andor ‘Me Too’ options.

Kind Regards

Raymond