Post reply

Replication subscription attempt fails with master key Error: 15581

  • October 5, 2023 at 7:23 pm

    #4302259

    Hello experts,

    I'm trying to create a replication subscription and got this error. Does anyone know how I can fix it without inadvertently messing up any encryption that the SQL Server has?

    Please create a master key in the database or open the master key in the session before performing this operation.

    Changed database context to 'dbname'. (Microsoft SQL Server, Error: 15581)

    Thanks for any help!

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • October 6, 2023 at 8:10 pm

    #4302972

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • October 6, 2023 at 8:59 pm

    #4302994

    presumably your publisher database has some sort of encryption enabled and the subscriber server does not have the encryption hierarchy available to handle it. The master key is near the top of the encryption hierarchy, you have to have one to be able to use any encryption feature implemented by sql (TDE, columnar encryption, backup encryption, etc)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply