2. ASPRunner.NET General questions
  3. [SOLVED] ERROR OPEN SYMMETRIC
This topic is locked
[SOLVED]

ERROR OPEN SYMMETRIC

 		4/30/2021 13:37:46
ASPRunner.NET General questions
acacio.rapaz@fastdata.pt author

Good afternoon,

After backup of sql in sql manager and reset on the final server I get this message:
Please create a master key in the database or open the master key in the session before performing this operation.

The user table has an encrypted password ... I don't know why it doesn't work.

Thanks.

img alt

Sergey Kornilov admin 4/30/2021

It looks like you also need to move your encryption key from the old database to a new one.

acacio.rapaz@fastdata.pt author 5/1/2021

how???
is there a how to??

Thanks...
Sergey Kornilov admin 5/2/2021

Yes, Google "sql server move symmetric key to another server"
acacio.rapaz@fastdata.pt author 5/2/2021

good day, thanks...