September 4, 2014 at 12:09 am
Hi,
how many log reader agent are created in transactional replication over 3 Databases.
will there be 3 agents? (as per msdn).
but when I was trying to configure peer to peer replication on the same instance which has already transactional replication... we are getting error .
showing Morethan 1 log reader agent can't run on the server.
Should I change the security in Publication properties for each db.
Plz help me.
September 4, 2014 at 6:11 am
SQL Server allows only one Log Reader Agent per transactionally replicated database.
for security related you can go through below
http://msdn.microsoft.com/en-us/library/ms189405(v=sql.90).aspx
September 4, 2014 at 11:24 pm
thanks for the post.
But I'm getting the error as shown .
September 9, 2014 at 7:14 am
?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply