Showing posts with label peer. Show all posts
Showing posts with label peer. Show all posts

Monday, March 19, 2012

can't "allow peer to peer" - SQL Server 2005

I'm trying to set up the first distribution server for a peer to peer transactional replication (updateable subscription) between two SQL Server 2005 instances on one machine (for testing). Can this be done without "virtual servers", and if so how do I enable the "Allow peer-to-peer subscriptions" option in the Subscription Options folder of the Publication Properties dialog box?

I've got:

Independent Distribution Agent True (not selectable)

Allow anonymous subscriptions False

Attachable subscription database False

Allow pull subscriptions False

Allow initialization from backup files True

Allow non-SQL Server Subscribers False

Allow data transformations False (not selectable)

Replicate schema changes True

Allow peer-to-peer subscriptions False (not selectable)

Allow immediate updating subscriptions True (not selectable)

Allow queued updating subscriptions True (not selectable)

Report conflicts centrally True

Conflict resolution policy Keep the Publisher

I've tried various combinations of options, but think these are correct. Also, the snapshot database is in a local (not network) directory; I got a warning on this, although in this special case the snapshot should be available to both instances.

Thanks...

I applied SQL Server 2005 SP1 and the problem went away!

Liston

Saturday, February 25, 2012

Cannot start Log Reader Agent and Snapshot Agent

I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.

For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).

This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"

Any ideas?

Also this domain account is a member of

SQLServer2005MSSQLUsers$ServerName$MSSQLSERVER

SQLServer2005MSAgentUser$ServerName$MSSQLSERVER


open the properties of each job and change the owner to sa and it should work fine.|||I tried it. No luck...it gives the same error message