June 29, 2009 at 1:44 pm
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
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
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
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
it excuted with zero rows affected
MCSE SQL Server 2012\2014\2016
June 29, 2009 at 3:10 pm
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
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
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
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