kingdonshel (9/21/2012)
After setting up Replication (Transactional Publication with updatable Subscription)between two instances one instance being both Distributor and Publisher, with the other being a Subscriber running on my local machine.
I managed to replicate data between instances from the publisher Instance, however whenever I try to update the table that is being replicated at the subscriber which should then instantly update the publisher I get the errors below.
ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) --- Server 'repl_distributor' is not configured for DATA ACCESS. (Microsoft SQL Server, Error: 7411)
The RPC security information for the Publisher is missing or invalid
Use
sp_link_publication to specify it
Publisher server is not configured for RPC
The publisher is set up for RPC and the distributor was configured for data access. Not sure how to replicate updates from subscriber back to publisher.
I have never worked with this replication scenario, however the error message to me is somewhat familiar. When you create replication, a linked server is created on the publisher end for the subscriber.
Do 1 thing. Set up a demo replication in test environment. Go the the linked server. Right click on that and in properties enable RPC and Data access. Let me know if this works.
Thanks
Chandan