Skip to main content
Nintex Community Menu Bar

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

  • July 16, 2021
  • 2 replies
  • 24 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

  • July 16, 2021

Thanks for these tips.


Forum|alt.badge.img+10
  • Nintex Employee
  • July 16, 2021

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