Getting error when setting up subscription

Question

Getting error when setting up subscription

sqlstar2011

SSCertifiable

Points: 6000
More actions
October 31, 2006 at 3:47 pm

#175084

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

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

debrucer1 SSCertifiable Points: 5366 More actions · Answer 1

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.

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

deepika.sharma-632099 Valued Member Points: 74 More actions · Answer 2

i m getting following 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 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??

sram24_mca SSCrazy Points: 2633 More actions · Answer 3

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

sandeep.chandi SSC Rookie Points: 37 More actions · Answer 4

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

deepika.sharma-632099 Valued Member Points: 74 More actions · Answer 5

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

AnilT SSC Enthusiast Points: 150 More actions · Answer 6

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

Anil

Gunjan Hall of Fame Points: 3226 More actions · Answer 7

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 1

The 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?

Thanks.

Gunjan.

Rich96 SSC Eights! Points: 947 More actions · Answer 8

deepika.sharma-632099 (2/17/2008)

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%5B/quote%5D

This resolved my issue when setting up a Subscription on a remote server.

gopi007d 69189 Grasshopper Points: 17 More actions · Answer 9

gopi007d 69189

Grasshopper

Points: 17

March 28, 2012 at 10:09 am

#1465791

Thanks, I resolved my issue

arbind_christy Newbie Points: 8 More actions · Answer 10

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 transaction

No Transaction is active Error:7391

Please help