<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 High Availability
»
Replication
15 posts, Page 1 of 2
1
2
»»
Replication
Rate Topic
Display Mode
Topic Options
Author
Message
kingdonshel
kingdonshel
Posted Friday, September 21, 2012 10:14 AM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:48 AM
Points: 31,
Visits: 140
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.
Post #1362825
chandan_jha18
chandan_jha18
Posted Wednesday, September 26, 2012 1:42 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 2:31 AM
Points: 412,
Visits: 1,671
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
Post #1364484
kingdonshel
kingdonshel
Posted Wednesday, September 26, 2012 1:14 PM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:48 AM
Points: 31,
Visits: 140
I did have that before if you look at the bottom of my posting you can see where I said RPC is already set to True.
Post #1364903
chandan_jha18
chandan_jha18
Posted Wednesday, September 26, 2012 10:34 PM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 2:31 AM
Points: 412,
Visits: 1,671
Sorry about that. Did you turn on the data access true as well?
Post #1365027
chandan_jha18
chandan_jha18
Posted Wednesday, September 26, 2012 10:38 PM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 2:31 AM
Points: 412,
Visits: 1,671
My gut feeling is that you can get this done by tweaking linked server only. I will try to re-produce this in my environment today.
Thanks
Chandan
Post #1365029
kingdonshel
kingdonshel
Posted Wednesday, September 26, 2012 11:36 PM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:48 AM
Points: 31,
Visits: 140
Yes I have set data access to true as well , however I dont see why I should have to if the link server is created automatically for replication from what I can see DATA ACCESS should be set to true, anyway I did.
When you try this in you environment remembr the type of Replication option I was trying was
Transactional Publication with updatable Subscriptions.
This allows changes to replication back to the publisher even when changes are made at the subscriber, it also allows changes to be replicated to the Subscirber even when updates is made at the Publisher.
I think part of the problem is the link server created on the distributer (repl_distributor) is run under the distributor_admin user --see Logins under Security. However the link server at the Subscriber is running under a different user.This happens automatically and there is no access to the password for these usernames.
I tried to set up my own Subscriber link server and tried to set up local to remote server mappings based on my admin user account however the link server could not connect ,I got the RPC Error message.
Also remember I am not on a network I am using my local machine which is running 2 Instanced.
Post #1365037
raj200986
raj200986
Posted Saturday, September 29, 2012 10:55 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, September 30, 2012 9:59 AM
Points: 1,
Visits: 2
Hello,
Did you started MSDTC, if not please start and allow inbound and outbound.
I think your problem should be resolved.
Post #1366230
kingdonshel
kingdonshel
Posted Sunday, September 30, 2012 11:21 AM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:48 AM
Points: 31,
Visits: 140
Thanks a million Raj, this works I droppped all link servers, users and logins created by replication, started MDTC in Services and recreated the type of replication described in my initial post. Now when I update the replicated table at the subcriber or publisher the updated table changes are updated in both places. Thank you so much.
This is the first time any of these sites has ever given me a solution that works, and thanks to for the suggestions from other user they helped to improve my knowledge.
Post #1366276
kingdonshel
kingdonshel
Posted Sunday, September 30, 2012 11:24 AM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:48 AM
Points: 31,
Visits: 140
Just to mention,I did not see any inbound or outbound option anywhere, I am using SQL Server 2008.
Post #1366278
chandan_jha18
chandan_jha18
Posted Monday, October 01, 2012 2:34 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 2:31 AM
Points: 412,
Visits: 1,671
kingdonshel (9/30/2012)
Just to mention,I did not see any inbound or outbound option anywhere, I am using SQL Server 2008.
I am glad that this worked for you. MSDTC options would be configured from windows level. Control panel has some option called 'add windows component' and there you can configure msdtc. Use web to find exact options to configure it for your OS.
Cheers!
Chandan
Post #1366392
« Prev Topic
|
Next Topic »
15 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
