March 25, 2009 at 10:41 am
I'm trying to set up peer to peer transactional replication in SQL Server 2008 from Server A (distributor, publisher) to Server B (subscriber) but I think I must be missing a step somewhere. I'm following the MSDN How To: on setting this up and it says:
1. Expand the Replication folder on Server A, and then expand the Local Publications folder.
2. Right-click the publication you created, and then click Properties.
3. In the Publication Properties - dialog box, on the Subscription Options page, select a value of True for the property Allow peer-to-peer subscriptions.
The problem is my Subscription Options page does not have an "Allow peer-to-peer subscriptions" option on it to set to True.
I'm assuming I missed something somewhere but have gone back through and can't see anything obvious. Anyone come across this one?
-tim
March 25, 2009 at 10:59 am
Only the Enterprise edition of SQL Server offers peer-to-peer replication.
Are you running enterprise?
March 25, 2009 at 12:38 pm
Apparently that is the problem. We have Standard, not Enterprise. Thanks Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply