Post reply

Master Key and certification Error

  • November 10, 2008 at 9:14 am

    #124839

    Guys,

    I have restored from one instance to another to setup Transaction Replication based on backup of the database

    when I set up the subscription I am getting the following error

    Messages

    SQL Server could not create a subscription for Subscriber 'NV-DEVSQL4\elroy'. (New Subscription Wizard)

    ------------------------------

    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

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

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

    Is there any way around it.

    Any suggestions and inputs would help

    Thanks

  • November 10, 2008 at 3:11 pm

    #896606

    I think what is happening is : one of the articles in your publication is encrypted \ using the database master key. So when the transactional replication tries to synchro its failing cause it needs the database master key.

    1. Either you should put a filter on the publication to eliminate the encrypted columns.

    or

    2. Change the replication procs on the subscriber to work in such a way that before doing DML operation you open the database master key for it.

    or

    3. May be its something similiar to orphan users ... i.e. you restored the database and the database master key which got restored corresponds to the service master key from publisher and not from subscriber.

    Hope that might lead you somewhere 🙂

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

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