SQL Server Performance

Error 7391

Discussion in 'SQL Server 2005 Replication' started by faridovski, Jun 12, 2007.

  1. faridovski New Member

    Hi
    any 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
  2. satya Moderator

  3. faridovski New Member

    thanks a lot a lot.

    i managed to do replication the problem was with virtual machine cloning.

    thanks
  4. satya Moderator

    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.

Share This Page