We are upgrading our SP application and database from SP2010 to SP2013 and our databases from 2008 to 2016.
However the application team doesnt have the DMK passwords only the files and certificates.
When they try to install the RBS client on the new machine and point to the restored SP databases they get the error attached.
I obviously cant open the database as i dont have the password and i cant drop the encryption again since i dont have a password.
A solution i already tried and worked was to do the following:
- Regenerate the password using force:Alter Master Key FORCE Regenerate
With Encryption By Password = '**********'
2. Drop the signatures on the objects which have signatures on them
3. Drop the certificates
4. Drop the DMK
5. Generate a new DMK
Is there another method which is easier or is this the only route to resolve this issue as well have to do this for all SP databases and i dont know if any data will be lost in the process!!