Merge replication in 2005... Version conflict?

I recently Upgraded both of my servers to SQL Server 2005 Standard.
Upon trying to set up Merge replication between the 2, I get this error:
For merge publications, the version of the Subscriber must not exceed the
version of the Publisher. (New Subscription Wizard)
They both have 2005 installed and updated (9.00.1399.00)
They both have the latest MDAC and .net versions
What could be causing this error?
Thanks!
what are the respective OSs? Could you post your publication script here?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:CA2A8A38-E07F-4C16-9C05-F58FA92D61F2@.microsoft.com...
>I recently Upgraded both of my servers to SQL Server 2005 Standard.
> Upon trying to set up Merge replication between the 2, I get this error:
> For merge publications, the version of the Subscriber must not exceed the
> version of the Publisher. (New Subscription Wizard)
> They both have 2005 installed and updated (9.00.1399.00)
> They both have the latest MDAC and .net versions
> What could be causing this error?
> Thanks!
|||They are both Running Windows 2000 server.
Here is the script:
-- Enabling the replication database
use master
exec sp_replicationdboption @.dbname = N'twistpos', @.optname = N'merge
publish', @.value = N'true'
GO
-- Adding the merge publication
use [twistpos]
exec sp_addmergepublication @.publication = N'AccGC', @.description = N'Merge
publication of database ''twistpos'' from Publisher ''SERVER''.', @.sync_mode
= N'native', @.retention = 14, @.allow_push = N'true', @.allow_pull = N'true',
@.allow_anonymous = N'true', @.enabled_for_internet = N'false',
@.snapshot_in_defaultfolder = N'true', @.compress_snapshot = N'false',
@.ftp_port = 21, @.ftp_login = N'anonymous', @.allow_subscription_copy =
N'false', @.add_to_active_directory = N'false', @.centralized_conflicts =
N'true', @.dynamic_filters = N'false', @.conflict_retention = 14,
@.keep_partition_changes = N'true', @.allow_synctoalternate = N'false',
@.max_concurrent_merge = 0, @.max_concurrent_dynamic_snapshots = 0
GO
exec sp_addpublication_snapshot @.publication = N'AccGC', @.frequency_type =
4, @.frequency_interval = 14, @.frequency_relative_interval = 1,
@.frequency_recurrence_factor = 0, @.frequency_subday = 1,
@.frequency_subday_interval = 5, @.active_start_time_of_day = 500,
@.active_end_time_of_day = 235959, @.active_start_date = 0, @.active_end_date =
0, @.snapshot_job_name = N'SERVER-twistpos-AccGC-6'
exec sp_grant_publication_access @.publication = N'AccGC', @.login =
N'BUILTIN\Administrators'
GO
exec sp_grant_publication_access @.publication = N'AccGC', @.login =
N'distributor_admin'
GO
exec sp_grant_publication_access @.publication = N'AccGC', @.login =
N'DOMAIN\Administrator'
GO
exec sp_grant_publication_access @.publication = N'AccGC', @.login = N'sa'
GO
-- Adding the merge articles
use [twistpos]
exec sp_addmergearticle @.publication = N'AccGC', @.article = N'GiftCards',
@.source_owner = N'dbo', @.source_object = N'GiftCards', @.type = N'table',
@.description = N'', @.creation_script = N'', @.pre_creation_cmd = N'drop',
@.schema_option = 0x0000000000004FF1, @.auto_identity_range = N'true',
@.pub_identity_range = 100000, @.identity_range = 100000, @.threshold = 90,
@.destination_owner = N'dbo', @.column_tracking = N'false',
@.subset_filterclause = N'', @.vertical_partition = N'false',
@.verify_resolver_signature = 1, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
use [twistpos]
exec sp_addmergearticle @.publication = N'AccGC', @.article = N'Account',
@.source_owner = N'dbo', @.source_object = N'Account', @.type = N'table',
@.description = N'', @.creation_script = N'', @.pre_creation_cmd = N'drop',
@.schema_option = 0x0000000000006FF1, @.auto_identity_range = N'false',
@.destination_owner = N'dbo', @.column_tracking = N'false',
@.subset_filterclause = N'', @.vertical_partition = N'false',
@.verify_resolver_signature = 1, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
"Hilary Cotter" wrote:

> what are the respective OSs? Could you post your publication script here?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Ben" <Ben@.discussions.microsoft.com> wrote in message
> news:CA2A8A38-E07F-4C16-9C05-F58FA92D61F2@.microsoft.com...
>
>
|||see this command? delete it,
- it works then - publication_compatibility_level = N'80RTM',
unless your subscriber really is SQL 2000 RTM. I would also advise you to
drop the existing subscription database and recreate it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:38EC9C88-370F-49D2-9257-D434E8BC6C30@.microsoft.com...[vbcol=seagreen]
> They are both Running Windows 2000 server.
> Here is the script:
> -- Enabling the replication database
> use master
> exec sp_replicationdboption @.dbname = N'twistpos', @.optname = N'merge
> publish', @.value = N'true'
> GO
> -- Adding the merge publication
> use [twistpos]
> exec sp_addmergepublication @.publication = N'AccGC', @.description =
> N'Merge
> publication of database ''twistpos'' from Publisher ''SERVER''.',
> @.sync_mode
> = N'native', @.retention = 14, @.allow_push = N'true', @.allow_pull =
> N'true',
> @.allow_anonymous = N'true', @.enabled_for_internet = N'false',
> @.snapshot_in_defaultfolder = N'true', @.compress_snapshot = N'false',
> @.ftp_port = 21, @.ftp_login = N'anonymous', @.allow_subscription_copy =
> N'false', @.add_to_active_directory = N'false', @.centralized_conflicts =
> N'true', @.dynamic_filters = N'false', @.conflict_retention = 14,
> @.keep_partition_changes = N'true', @.allow_synctoalternate = N'false',
> @.max_concurrent_merge = 0, @.max_concurrent_dynamic_snapshots = 0
> GO
>
> exec sp_addpublication_snapshot @.publication = N'AccGC', @.frequency_type =
> 4, @.frequency_interval = 14, @.frequency_relative_interval = 1,
> @.frequency_recurrence_factor = 0, @.frequency_subday = 1,
> @.frequency_subday_interval = 5, @.active_start_time_of_day = 500,
> @.active_end_time_of_day = 235959, @.active_start_date = 0, @.active_end_date
> =
> 0, @.snapshot_job_name = N'SERVER-twistpos-AccGC-6'
> exec sp_grant_publication_access @.publication = N'AccGC', @.login =
> N'BUILTIN\Administrators'
> GO
> exec sp_grant_publication_access @.publication = N'AccGC', @.login =
> N'distributor_admin'
> GO
> exec sp_grant_publication_access @.publication = N'AccGC', @.login =
> N'DOMAIN\Administrator'
> GO
> exec sp_grant_publication_access @.publication = N'AccGC', @.login = N'sa'
> GO
> -- Adding the merge articles
> use [twistpos]
> exec sp_addmergearticle @.publication = N'AccGC', @.article = N'GiftCards',
> @.source_owner = N'dbo', @.source_object = N'GiftCards', @.type = N'table',
> @.description = N'', @.creation_script = N'', @.pre_creation_cmd = N'drop',
> @.schema_option = 0x0000000000004FF1, @.auto_identity_range = N'true',
> @.pub_identity_range = 100000, @.identity_range = 100000, @.threshold = 90,
> @.destination_owner = N'dbo', @.column_tracking = N'false',
> @.subset_filterclause = N'', @.vertical_partition = N'false',
> @.verify_resolver_signature = 1, @.allow_interactive_resolver = N'false',
> @.fast_multicol_updateproc = N'true', @.check_permissions = 0
> GO
> use [twistpos]
> exec sp_addmergearticle @.publication = N'AccGC', @.article = N'Account',
> @.source_owner = N'dbo', @.source_object = N'Account', @.type = N'table',
> @.description = N'', @.creation_script = N'', @.pre_creation_cmd = N'drop',
> @.schema_option = 0x0000000000006FF1, @.auto_identity_range = N'false',
> @.destination_owner = N'dbo', @.column_tracking = N'false',
> @.subset_filterclause = N'', @.vertical_partition = N'false',
> @.verify_resolver_signature = 1, @.allow_interactive_resolver = N'false',
> @.fast_multicol_updateproc = N'true', @.check_permissions = 0
> GO
> "Hilary Cotter" wrote:
|||You still have it set in 80 compatibility mode.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:CA2A8A38-E07F-4C16-9C05-F58FA92D61F2@.microsoft.com...
>I recently Upgraded both of my servers to SQL Server 2005 Standard.
> Upon trying to set up Merge replication between the 2, I get this error:
> For merge publications, the version of the Subscriber must not exceed the
> version of the Publisher. (New Subscription Wizard)
> They both have 2005 installed and updated (9.00.1399.00)
> They both have the latest MDAC and .net versions
> What could be causing this error?
> Thanks!
|||OK... So here's what I figured out.
In Object Explorer, I see my subscription server as version 9.0.1399, but
the publication server is still marked 8.0.194.
How do I upgrade the publication server to 9.0.1399?
Do I still need to drop the old merge replication? How do I go about that?
Thanks for the help... still new to this 2005 thing.
"Hilary Cotter" wrote:

> see this command? delete it,
> - it works then - publication_compatibility_level = N'80RTM',
> unless your subscriber really is SQL 2000 RTM. I would also advise you to
> drop the existing subscription database and recreate it.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Ben" <Ben@.discussions.microsoft.com> wrote in message
> news:38EC9C88-370F-49D2-9257-D434E8BC6C30@.microsoft.com...
>
>
|||OK, I'm really confused here. Can you issue a select @.@.version on your
publisher and post it here marked publisher, and do the same on your
subscriber and post it here marked subscriber.
You can't create SQL 2005 publications on SQL 2000 publishers - there is
something very wrong here. Besides I was able to repro your problem between
two SQL 2005 machines.
To drop the existing merge publications, right click on it in Enterprise
Manager or SQL Server Management Studio. and select Delete.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:3B87E513-4C0E-4294-B45D-273485DDD94F@.microsoft.com...[vbcol=seagreen]
> OK... So here's what I figured out.
> In Object Explorer, I see my subscription server as version 9.0.1399, but
> the publication server is still marked 8.0.194.
> How do I upgrade the publication server to 9.0.1399?
> Do I still need to drop the old merge replication? How do I go about that?
> Thanks for the help... still new to this 2005 thing.
> "Hilary Cotter" wrote:
|||Just change the database compatibility level within the database properties.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:3B87E513-4C0E-4294-B45D-273485DDD94F@.microsoft.com...[vbcol=seagreen]
> OK... So here's what I figured out.
> In Object Explorer, I see my subscription server as version 9.0.1399, but
> the publication server is still marked 8.0.194.
> How do I upgrade the publication server to 9.0.1399?
> Do I still need to drop the old merge replication? How do I go about that?
> Thanks for the help... still new to this 2005 thing.
> "Hilary Cotter" wrote:
|||The instance had not been updated. Reattatched and everything was fine.
Thanks for the help.
Ben
"Michael Hotek" wrote:

> Just change the database compatibility level within the database properties.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "Ben" <Ben@.discussions.microsoft.com> wrote in message
> news:3B87E513-4C0E-4294-B45D-273485DDD94F@.microsoft.com...
>
>