SQL Server Performance Forum – Threads Archive
Error 7391
Hiany help is appreciated.
i have two machine joined to a domain and i
am trying to set up a transactional replication with updatable subscription.
both machine are windows 2003 sp2 and sql server 2005 sp1.
when i create subscription it gives me a warning: he operation could not be performed because OLE DB provider "SQLNCLI" for linked server "REPLLINK_TDSQL2K511040874026_WWJD981144955_WWJDRE-220847657_MASTER-1041306886" was unable to begin a distributed transaction. i have changed the services of SQL to run under domain account.
i have enabled DTC.
both linked servers have RPC and RPC OUT enabled. i have tried sp_link_publication it gives the same error always. please help needed
http://support.microsoft.com/kb/306212 fyi to perform a check through.
Alsohttp://www.chriskempster.com/articles/debugdtcissues.htm to debug DTC issues. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
thanks a lot a lot. i managed to do replication the problem was with virtual machine cloning. thanks
Hm, that is the another problem using VM in this case.
Glad you are able to resolve and appreciate your feedback, that helps. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>