SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Replication


Replication

Author
Message
Paul Clark-418949
Paul Clark-418949
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 228
As an addition to the above with MSDTC. If you are suing VMWare and deploying virtual machines from a Template, you may also see this error when setting up replication as the cids for msdtc will probably be the same.

I have written a quick blog post on this:
[url=http://paulmjclark.blogspot.co.uk/2012/09/dtc-error-warning-cid-values-for-bothe.html][/url]

This behaviour can cause quite a few issues with SQL Server so it's a good one to watch out for in a Virual Server Environment....
saidapurs
saidapurs
Right there with Babe
Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)

Group: General Forum Members
Points: 751 Visits: 414
Hi Raj,

I have a doubt, we commonly using MSDTC in cluster environment and i am configured lot of times replication but never touch the MSDTC services. Could you please collaborate this one..

Thanks
Satish
Paul Clark-418949
Paul Clark-418949
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 228
saidapurs (10/4/2012)
Hi Raj,

I have a doubt, we commonly using MSDTC in cluster environment and i am configured lot of times replication but never touch the MSDTC services. Could you please collaborate this one..

Thanks
Satish


Hi Satish,

My reply was in regards to duplicate cids if you are deploying Virtual Servers from a preconfigured template.

You don't necessarily have to configure MSDTC for replication, but it does need to be running, from what I remember SQL would use MSDTC for the linked servers it creates when you set up Replication....

See the below from a post in the MSDN Forums:

http://social.msdn.microsoft.com/Forums/is/sqlreplication/thread/9eac926e-18e8-481e-9028-0269ddc1a2ae

Cheers Paul
MMartin1
MMartin1
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7271 Visits: 2033
You'll need MS DTC running if you are using 'immediate updating' updateable subscriptions. The other option is 'queued updating.' Here the changes are stored at the client and pushed when the publisher can be contacted.

----------------------------------------------------
How to post forum questions to get the best help
kingdonshel
kingdonshel
Old Hand
Old Hand (376 reputation)Old Hand (376 reputation)Old Hand (376 reputation)Old Hand (376 reputation)Old Hand (376 reputation)Old Hand (376 reputation)Old Hand (376 reputation)Old Hand (376 reputation)

Group: General Forum Members
Points: 376 Visits: 216
"Did you started MSDTC, if not please start and allow inbound and outbound.
I think your problem should be resolved"

Hi guys in earlier post Raj suggested to turn on MSDTC, I turned it on in Serviced and my configured Repliction (Transactional Publication with updatable Subscription)
started to work. In his post he mentionded that I should allow inbouns and outbound when I turned on MSDTC, does anyone knows what or where inbound and outbound is,since I did not see those options when I turned on MSDTC.
rabrahams
rabrahams
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 5
Thanks, this helped loads on our production environment. I can confirm that MSDTC does not need to be enabled when the subscriber is set to "Queue Changes and commit when possible". IF its set to "Immediate" you going to need to Enable Network DTC.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search