Database with master key

Question

A Citrix database created with some Citrix Wem tool have a symmetric key where it was once created. Trying to move database no another server and is prevented to add to Availability group because of the master key. Been searching for this and as database is not encrypted I followed some instruction to drop the master key from the Citrix Wem db. But as it is in use in sys.conversation_endpoints it can't be dropped. What's the conversation_endpoint used for? Is it possible to get rid of so that I can remove the master key?

Answer 1

Hi Jockehome,

I did not know about Citrix Wem tool. But for SQL server database, we can use DROP MASTER KEY statement to remove the master key from the current database.

Please compare your situation with below blog and try the solutions from below blogs.

SQL SERVER – Error 15580 – Cannot Drop Master Key
Drop Master Key ! – Understanding encryption hierarchy

Best regards,
Cathy

Answer 2

Good day,

What's the conversation_endpoint used for?

conversation_endpoint is used by Service Broker conversation in order to represent the conversation endpoint.

Is it possible to get rid of so that I can remove the master key?

If this is not in-used then yes but probably there is a reason that your database use the conversation_endpoints then how do you want to remove it?

You will first need to find the source which use this and check what you want to do.