Replication between SQL 2000 and SQL 2005

Question

Post reply

Replication between SQL 2000 and SQL 2005

jsweet-1095634

SSC Enthusiast

Points: 176
More actions
May 28, 2009 at 2:13 pm

#200987

Hello all,
I am trying to subscribe to a SQL 2000 publisher from a 2005 subscriber. I initially got an error (Microsoft SQL Server, Error: 20620) that I discovered had some thing to do with MSDTC and also that the linked server was not in sys.servers. I made modifications to both boxes' DTC config and also ran sp_addlinkedserver. Now when I add the subscription in 2005, I get the below error:
"TITLE: New Subscription Wizard
------------------------------
SQL Server could not create a subscription for Subscriber 'SQLSERVER2'.
------------------------------
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_TESTDB-476673284_DBxx_DB717017582_DBxx_DBREPL-280078859_Dbxx_DB717017582" was unable to begin a distributed transaction.
Changed database context to 'DBxx_db'.
OLE DB provider "SQLNCLI" for linked server "REPLLINK_TESTDB-476673284_DBxx_DB717017582_DBxx_DBREPL-280078859_DBxx_DB717017582" returned message "No transaction is active.". (Microsoft SQL Server, Error: 7391)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3077&EvtSrc=MSSQLServer&EvtID=7391&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
"
Can anyone post a brief step by step of how they successfully subscribed to a 2000 server from 2005?
Thanks!
Jamy

Viewing 7 posts - 1 through 6 (of 6 total)

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

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 1

Hi

Which type of replication are you using?

The link below shows you the support type and editions.

http://msdn.microsoft.com/en-us/library/ms143241(SQL.90).aspx

JL

jsweet-1095634 SSC Enthusiast Points: 176 More actions · Answer 2

Hey JL,

Thanks for the article. I already read that and what I am using is compatible with their charts. Not sure I follow with your question as to what type of replication I am using?

Cheers,

J

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 3

Are you using merged, transactional, transactional with sub updates, P2P or snapshot?

JL

jsweet-1095634 SSC Enthusiast Points: 176 More actions · Answer 4

jsweet-1095634

SSC Enthusiast

Points: 176

May 29, 2009 at 10:34 am

#1002170

Transactional

Vinay Thankur SSCarpal Tunnel Points: 4178 More actions · Answer 5

http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx

HTH

Vin

Thanx.
Vinay

http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay

jsweet-1095634 SSC Enthusiast Points: 176 More actions · Answer 6

Thanks Vinay!

Those steps worked great and the aforementioned error is gone. One thing though, I think I might have something set incorrectly because the subscriber database has no tables in it, any thoughts?

Thanks again,

Jamy