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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply