June 29, 2009 at 8:37 am
I am trying to add a 2008 subscriber to a 2005 box for replication. Does anybody know how to add it without getting this error?
The selected subscriberdoes not satisfy the minimum version compatibility level of selected publication
thanks,
:w00t:
MCSE SQL Server 2012\2014\2016
June 29, 2009 at 8:46 am
Can you please let us know what compatibility level you have set for your publisher and subscriber?
-Roy
June 29, 2009 at 8:50 am
One server (2005) is 9.0
second server (2008) is 10
When setting up the Publisher can I select a higher level?
MCSE SQL Server 2012\2014\2016
June 29, 2009 at 9:02 am
Your publisher is 2005...Right? You cannot set it higher than 90 that you have.... I am not sure why you are not able to replicate from 2005 to 2008. There are lots of cases where it is set up successfully.
-Roy
June 29, 2009 at 9:05 am
Sorry both DB's are 9.0 but one of them is on the 2008 server which is 10.
Roy,
I cannot get the server to connect when adding a new subscription in the wizard on the 2005 box. If there's a way can you help me out?
This is the error I get
'The selected subscriber does not satisfy the minimum version compatibility level of selected publication'
:w00t:
MCSE SQL Server 2012\2014\2016
June 29, 2009 at 9:29 am
Your issue is a small one. You cannot add a 2008 subscriber from the 2005 SSMS. This is due to the fact that SSMS is only backward compatible and not forward compatible.
Try adding the subscriber from the SQL 2008 box using SQL Server Management Studio.
-Roy
June 29, 2009 at 10:27 am
I get this error when making it a subscriber on the 2008 box
TITLE: New Subscription Wizard
------------------------------
SQL Server could not create a subscription for Subscriber 'ECA-DC-SQLREP1'.
------------------------------
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 'CampusVue'. (Microsoft SQL Server, Error: 15581)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=15581&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
MCSE SQL Server 2012\2014\2016
June 29, 2009 at 11:47 am
Go it! Thanks
On the 2005 box I mad a publication for my DB
On my 2008 box I made a subscription using distributor (pull) option
so this will pull the original DB from 2005 and replicate on 2008 box.
MCSE SQL Server 2012\2014\2016
June 29, 2009 at 1:22 pm
Glad to know that everything worked out fine...
-Roy
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply