SQLServerCentral / SQL Server 2005 / SS2K5 Replication / Getting error when setting up subscription / Latest Posts

RE: Getting error when setting up subscription

arbind_christy — Sun, 30 Dec 2012 09:24:12 GMT

Hi I am having similar kind of error.Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication.ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The operation could not be performed because the OLE DB provider "SQLNCLI10" for the linked server was unable to begin a distributed transactionNo Transaction is active Error:7391Please help

RE: Getting error when setting up subscription

gopi007d 69189 — Wed, 28 Mar 2012 10:09:04 GMT

Thanks, I resolved my issue

RE: Getting error when setting up subscription

Rich96 — Wed, 23 Sep 2009 06:51:26 GMT

[quote][b]deepika.sharma-632099 (2/17/2008)[/b][hr]my issue got resolved by following step:To allow the network transaction, you must enable MSDTC. To do this, follow these steps: a. Click Start, and then click Run. b. In the Run dialog box, type dcomcnfg.exe, and then click OK. c. In the Component Services window, expand Component Services, expand Computers, and then expand My Computer. d. Right-click My Computer, and then click Properties. e. In the My Computer Properties dialog box, click Security Configuration on the MSDTC tab. f. In the Security Configuration dialog box, click to select the Network DTC Access check box. g. To allow the distributed transaction to run on this computer from a remote computer, click to select the Allow Inbound check box. h. To allow the distributed transaction to run on a remote computer from this computer, click to select the Allow Outbound check box. i. Under the Transaction Manager Communication group, click to select the No Authentication Required option. j. In the Security Configuration dialog box, click OK. k. In the My Computer Properties dialog box, click OK. source: http://support.microsoft.com/?kbid=873160[/quote]This resolved my issue when setting up a Subscription on a remote server.

RE: Getting error when setting up subscription

Gunjan — Tue, 10 Jun 2008 12:26:23 GMT

I am using getting the following error INSERT TempErrorDetailsParameters Exec DBServer.DBName.dbo.GetEmployees '03/01/2008','03/31/2008'OLE DB provider "SQLNCLI" for linked server "DBServer" returned message "No transaction is active.".Msg 7391, Level 16, State 2, Line 1The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "DBServer" was unable to begin a distributed transaction.I have set the MS DTC. It works but suddenly it stops working and throws the error.What to do now?

RE: Getting error when setting up subscription

AnilT — Thu, 05 Jun 2008 10:13:31 GMT

I have had exactly the same problem, now solved thanks to your post.Anil

RE: Getting error when setting up subscription

deepika.sharma-632099 — Sun, 17 Feb 2008 21:41:41 GMT

my issue got resolved by following step:To allow the network transaction, you must enable MSDTC. To do this, follow these steps: a. Click Start, and then click Run. b. In the Run dialog box, type dcomcnfg.exe, and then click OK. c. In the Component Services window, expand Component Services, expand Computers, and then expand My Computer. d. Right-click My Computer, and then click Properties. e. In the My Computer Properties dialog box, click Security Configuration on the MSDTC tab. f. In the Security Configuration dialog box, click to select the Network DTC Access check box. g. To allow the distributed transaction to run on this computer from a remote computer, click to select the Allow Inbound check box. h. To allow the distributed transaction to run on a remote computer from this computer, click to select the Allow Outbound check box. i. Under the Transaction Manager Communication group, click to select the No Authentication Required option. j. In the Security Configuration dialog box, click OK. k. In the My Computer Properties dialog box, click OK. source: http://support.microsoft.com/?kbid=873160

RE: Getting error when setting up subscription

sandeep.chandi — Fri, 15 Feb 2008 22:00:02 GMT

Hi all,When i do replication from the same machine on different instances it works fine. But between different machines it gives the same error as mentionend in the previous post. Everything related to remote connections has been enabled on both the servers. I have added both servers in Linked server lists of each other as well.Please help as soon as possible. Regards

RE: Getting error when setting up subscription

sram24_mca — Wed, 06 Feb 2008 21:32:43 GMT

Hi, Can you check the network configuration in SQLSERVER surface area configuration whether all the services is having the remote connection permission or not.Regards,ram

RE: Getting error when setting up subscription

deepika.sharma-632099 — Wed, 06 Feb 2008 00:20:02 GMT

i m getting following errorunable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication.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_PRODSK0474-830409266_NETSOFT967703635_PUBLISHER-2139572905_NETSOFTSUB1650910173" was unable to begin a distributed transaction. Changed database context to 'NetSoftSubscriber'. OLE DB provider "SQLNCLI" for linked server "REPLLINK_PRODSK0474-830409266_NETSOFT967703635_PUBLISHER-2139572905_NETSOFTSUB1650910173" returned message "The partner transaction manager has disabled its support for remote/network transactions.". (Microsoft SQL Server, Error: 7391)can anyone help??

RE: Getting error when setting up subscription

debrucer1 — Tue, 31 Oct 2006 17:18:00 GMT

I would start by seeing what is currently in sysservers... and if the desired server is not there, I would use the sp_addlinkedserver procedure they name in the message to get it there...

are you replicating the reportserver db? How interesting.

I didn't bother to follow the link... did you?

Let us know how you fixed it.

Getting error when setting up subscription

sqlstar2011 — Tue, 31 Oct 2006 15:47:00 GMT

I get the following error when setting up subscription:

Creating Subscription(s)...
- Creating subscription for 'CISSW-YUKON04' (Warning)
Messages

Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------The security mode specified requires the server 'CISSW-YUKON03' in sysservers. Use sp_addlinkedserver to add the server.Changed database context to 'ReportServer'. (Microsoft SQL Server, Error: 20620)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=20620&LinkId=20476

any ideas?

thanks