Settin' up a Transactional Replication
Posted on 2011-02-13
We have 2 servers A and B.
There is already a snapshot replication set up between A & B. And now Iam supposed to setup a transactional replication with updateable subscription on the same A & B, but as this req requires a linked server, I also had trouble in creating one.Whenever I tried to create a linked server on the publisher on A, I was not able to map a login to impersonate, the logins does not show up at all....
So thinking that I could succeed with simple tran replication tried to do it the following way:
Since distributor is already configured on the publisher A, I have created a push publication on A(which is also the distributor) and also the subscriber on another server.
Though it didnt give me any errors, the snapshot is not running even when tried to run it manually from the replication monitor.
Tried to configure it few more times but in vain...
And then poured some efforts in googling and found that it could be fixed thru sp_link_publication...but again while providing login details as parameters it is not accepting the same. I have a win NT login with sa admin privilages and am using the same for accessing diff severs and for setting up HA features also.
I have tried to create the tran replication on a fresh databases on my test servrs and succeeded :)
I agree that Im naive while creating one in an existing environment, So I seriously need ur help from you experts...please lend a helping hand in getting this done.
Lemme know if you need more info...as I may be missing some imp detail for you to understand.
Thanks in advance for all who put in ur efforts in working towards fixing my issue and for also sharing ur valuable info and ur invalubale expertise with me :)