Transactional replication - 2005

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

SQL Server Administration (2005)

Transactional replication - 2005

Author

Topic

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2008-06-20 : 06:12:46

Hi All,

I am trying to configure Transactional replication with updatable subscription sql server 2005 with service pack 2.

Creating distributor and publisher on the same box, but subscriber on a different server.

Distributor and publisher are configured without any problem but when I try configuring subscriber, it throws below warning.

TITLE: New Subscription Wizard
------------------------------

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_QA-WIN2K3-1413475264_ADVENTUREW1643387368_WELLCORE-542849619_ADVENTUREW1643387368" was unable to begin a distributed transaction.
Changed database context to 'AdventureWorks'.
OLE DB provider "SQLNCLI" for linked server "REPLLINK_QA-WIN2K3-1413475264_ADVENTUREW1643387368_WELLCORE-542849619_ADVENTUREW1643387368" returned message "The transaction manager has disabled its support for remote/network transactions.". (Microsoft SQL Server, Error: 7391)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3152&EvtSrc=MSSQLServer&EvtID=7391&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

I tried setting this up directly on the Subscriber machine using sp_link_publication but the same error.

Any help or suggestion are welcome.

Thanks
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-20 : 08:11:10

Does SQL server run on Domain account? Is DTC enabled?

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2008-06-20 : 08:31:08

Does SQL server run on Domain account?
Answer: Yes

Is DTC enabled?
Answer: Yes

Don't sit back because of failure. It will come back to check if you still available. -- Binu

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-20 : 10:30:21

quote:
Originally posted by sachinsamuel

Does SQL server run on Domain account?
Answer: Yes

Is DTC enabled?
Answer: Yes

Don't sit back because of failure. It will come back to check if you still available. -- Binu

Does SQL Server agent run on Same domain acccount in both servers or are they trusted?

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2008-06-20 : 13:26:55

Yes. SQL server agent running on the same domain account.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

contrari4n
Starting Member

27 Posts

Posted - 2008-06-20 : 18:31:44

Have a look at this article: http://support.microsoft.com/?kbid=873160

It could be that Network Access is not enabled for DTC, or you have a firewall blocking it.

Richard
http://www.sql-server-pro.com
SQL Server Articles and Tips

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-20 : 23:27:59

>> You may have to set this up directly on the Subscriber machine using sp_link_publication.

You need run following on subscriber:

sp_link_publication @publisher='host_name', @publisher_db='db_name', @publication='pub_name', @security_mode=0, @login='sa', @password=''

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2008-06-21 : 07:24:57

Thank you very much Richard. That helped.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources