Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Getting error when setting up subscription Expand / Collapse
Author
Message
Posted Tuesday, October 31, 2006 3:47 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 4, 2013 11:06 AM
Points: 397, Visits: 548

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

Post #319456
Posted Tuesday, October 31, 2006 5:18 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 4, 2014 2:28 PM
Points: 254, Visits: 136

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.



Thanks,

David Russell
Oracle Since 1982
SQL Server Since 1998
Post #319478
Posted Wednesday, February 6, 2008 12:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2008 12:38 AM
Points: 4, Visits: 32
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??
Post #452033
Posted Wednesday, February 6, 2008 9:32 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 24, 2014 2:11 AM
Points: 91, Visits: 400
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
Post #452548
Posted Friday, February 15, 2008 10:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 10, 2014 1:37 AM
Points: 19, Visits: 51
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
Post #456600
Posted Sunday, February 17, 2008 9:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2008 12:38 AM
Points: 4, Visits: 32
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
Post #456775
Posted Thursday, June 5, 2008 10:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 14, 2012 1:44 AM
Points: 36, Visits: 86
I have had exactly the same problem, now solved thanks to your post.

Anil



Post #512281
Posted Tuesday, June 10, 2008 12:26 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:37 PM
Points: 78, Visits: 284
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.
Post #514718
Posted Wednesday, September 23, 2009 6:51 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 24, 2013 3:29 PM
Points: 67, Visits: 236
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


This resolved my issue when setting up a Subscription on a remote server.
Post #792578
Posted Wednesday, March 28, 2012 10:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 25, 2014 4:17 AM
Points: 1, Visits: 111
Thanks, I resolved my issue
Post #1274433
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse