We are upgrading Database Sql 2012 to Sql 2014, the connection to the database needs to be updated.

  • 16 July 2021
  • 2 replies
  • 11 views

Dear All,


As part of Sql server upgrade, we are migrating databases to new server.so far we have done below activities.

1. Create a backup of the K2 Database
2. Stop the K2 Blackpearl Service

3. Restore K2 Database to new sql server 2014.

we are facing issue when we tried starting K2 blackpearl server 4.6.11.For exception please find below details:

  • 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.
  •  

18843i115DF57D7EF96DD5.png

appreciate your help in fixing above issue.

 

Thanks

 


2 replies

Thanks for these tips.

Userlevel 2
Badge +10

Hi Umamaheswar,


 


It looks like the 'SCSSOKey' need to rebuild, I would recommend logging a case for this.


 


https://community.nintex.com/t5/Technical-Issues/Known-Issue-Moving-or-Restoring-a-K2-database-to-a-new-SQL/ta-p/123374

Reply