Database with master key

Jocke @home 1 Reputation point
2020-08-20T14:25:31.697+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,558 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. CathyJi-MSFT 20,666 Reputation points Microsoft Employee
    2020-08-21T03:43:42.467+00:00

    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


  2. Ronen Ariely 13,786 Reputation points Microsoft MVP
    2020-08-21T04:10:57.71+00:00

    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.

    No comments