Post reply

Creating Subscriber getting error

  • June 29, 2009 at 1:44 pm

    #206527

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

    Changed database context to 'DB1'. (.Net SqlClient Data Provider)

    I am also getting this error when trying to create a subscriber to pull from 2005 DB1 to 2008 DB1

    You have selected the Publisher as a Subscriber and entered a subscription database that is the same as the publishing database. Select another subscription database.

    :crazy:

    I just want to replicate!

    MCSE SQL Server 2012\2014\2016

  • June 29, 2009 at 2:47 pm

    #1017202

    Do you have encryption set up on your publisher or subscriber? That is when you get the master key errors.

    -Roy

  • June 29, 2009 at 2:50 pm

    #1017208

    I have no idea, is there a query I can run to find out.

    I just love going behind others work. :w00t:

    MCSE SQL Server 2012\2014\2016

  • June 29, 2009 at 2:56 pm

    #1017220

    Try this query...

    USE master;

    GO

    SELECT * FROM sys.symmetric_keys WHERE name LIKE '%MS_DatabaseMasterKey%'

    GO

    -Roy

  • June 29, 2009 at 2:59 pm

    #1017224

    it excuted with zero rows affected

    MCSE SQL Server 2012\2014\2016

  • June 29, 2009 at 3:10 pm

    #1017242

    This error comes up when there is a master key set up for your 2008 or 2005 box. I am a bit lost here. I will try to get some help from the gurus here..

    -Roy

  • June 29, 2009 at 3:55 pm

    #1017273

    I think I found the issue, Running around in circles is fun!

    thanks!

    MCSE SQL Server 2012\2014\2016

  • June 29, 2009 at 3:56 pm

    #1017276

    Let me know I could use all the help I can get.

    MCSE SQL Server 2012\2014\2016

  • June 30, 2009 at 7:52 am

    #1017575

    Sounds like the database was encrypted. It wants the location of the key files and you'll need the passwords that unlock them.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 9 posts - 1 through 8 (of 8 total)

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