Transactional Replication Problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Transactional Replication Problem

Author

Topic

hdv212
Posting Yak Master

140 Posts

Posted - 2007-11-21 : 00:29:02

hi
i maked transactional replication between two computers on the network,i was configured and created publisher and in another computer when i want to create subscriber and followed wizard and click ok, the following message has shown me :

TITLE: New Subscription Wizard
------------------------------
SQL Server could not create a subscription for Subscriber 'RAD860513\I1'.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "REPLLINK_MYLAPTOP692949684_NORTHWIND-814528215_P_TR_11889996770_S1554471694" was unable to begin a distributed transaction.
Changed database context to 's1'.
OLE DB provider "SQLNCLI" for linked server "REPLLINK_MYLAPTOP692949684_NORTHWIND-814528215_P_TR_11889996770_S1554471694" returned message "The partner transaction manager has disabled its support for remote/network transactions.". (Microsoft SQL Server, Error: 7391)

i started dtc (distributed transaction query) in both computers and also set xact_abort on in both.
where does my problem ?
thanks

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-11-21 : 04:10:59

are you using linked servers?

see this:-

http://support.microsoft.com/kb/816701

Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-11-21 : 04:31:45

Sorry just noticed that you have allready tryed that.

Have you looked at the following?

http://groups.google.com/group/microsoft.public.sqlserver.server/msg/127255ab5a3a1fe0?hl=en&lr=&ie=UTF-8&oe=UTF-8

Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.

hdv212
Posting Yak Master

140 Posts

Posted - 2007-11-21 : 07:06:05

thanks for reply
i don't have windows server 2003, i have win xp pro sp2 in both computers, how to install msdtc in win xp sp2 pro and configure it currently ?
thanks

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-11-21 : 07:31:18

Is there a sevrice under the sevrices called msdtc?

If not try this:-

In command promt go to c:\windows\system32

and run msdtc - install

Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.

hdv212
Posting Yak Master

140 Posts

Posted - 2007-11-21 : 10:05:32

thanks for reply.
how to run msdtc manually ?
thanks

hdv212
Posting Yak Master

140 Posts

Posted - 2007-11-22 : 12:03:59

where i look at services in administrative tools, dtc is running, also in management studio it is running but for test when i create linkServer and use distributed transaction, error has shown me that msdtc is not available, where does my problem ?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-22 : 16:48:44

Did you enable remote access on subscriber?

hdv212
Posting Yak Master

140 Posts

Posted - 2007-11-22 : 17:22:43

i started dtc in both computers and set xact_abort on in both, what is remote access ?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-22 : 17:29:34

It's sql server setting, double check it in sql server configuration manager. Also check if sql browser service is running.